Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 1163265 |
| Missing cells | 593331 |
| Missing cells (%) | 1.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 284.0 MiB |
| Average record size in memory | 256.0 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 3 |
| Categorical | 13 |
| Text | 9 |
agency has constant value "" | Constant |
agency_name has constant value "" | Constant |
complaint_type has constant value "" | Constant |
location_type has constant value "" | Constant |
address_type is highly overall correlated with city and 1 other fields | High correlation |
bbl is highly overall correlated with borough and 3 other fields | High correlation |
borough is highly overall correlated with bbl and 2 other fields | High correlation |
city is highly overall correlated with address_type and 3 other fields | High correlation |
incident_zip is highly overall correlated with bbl and 1 other fields | High correlation |
latitude is highly overall correlated with park_borough and 1 other fields | High correlation |
longitude is highly overall correlated with park_borough and 1 other fields | High correlation |
park_borough is highly overall correlated with bbl and 5 other fields | High correlation |
park_facility_name is highly overall correlated with address_type | High correlation |
x_coordinate_state_plane is highly overall correlated with longitude | High correlation |
y_coordinate_state_plane is highly overall correlated with latitude | High correlation |
address_type is highly imbalanced (79.4%) | Imbalance |
status is highly imbalanced (99.8%) | Imbalance |
park_facility_name is highly imbalanced (> 99.9%) | Imbalance |
location_type has 11886 (1.0%) missing values | Missing |
address_type has 215156 (18.5%) missing values | Missing |
city has 83650 (7.2%) missing values | Missing |
landmark has 83662 (7.2%) missing values | Missing |
bbl has 141586 (12.2%) missing values | Missing |
unique_key has unique values | Unique |
Reproduction
| Analysis started | 2023-12-05 19:12:15.960332 |
|---|---|
| Analysis finished | 2023-12-05 19:23:24.590273 |
| Duration | 11 minutes and 8.63 seconds |
| Software version | ydata-profiling vv4.6.2 |
| Download configuration | config.json |
unique_key
Real number (ℝ)
UNIQUE 
| Distinct | 1163265 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55011271 |
| Minimum | 48536309 |
|---|---|
| Maximum | 59631559 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 48536309 |
|---|---|
| 5-th percentile | 50127161 |
| Q1 | 52690582 |
| median | 55269127 |
| Q3 | 57474905 |
| 95-th percentile | 59196675 |
| Maximum | 59631559 |
| Range | 11095250 |
| Interquartile range (IQR) | 4784323 |
Descriptive statistics
| Standard deviation | 2875076.4 |
|---|---|
| Coefficient of variation (CV) | 0.052263406 |
| Kurtosis | -1.067847 |
| Mean | 55011271 |
| Median Absolute Deviation (MAD) | 2371015 |
| Skewness | -0.22653672 |
| Sum | 6.3992687 × 1013 |
| Variance | 8.2660643 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52934348 | 1 | < 0.1% |
| 59243775 | 1 | < 0.1% |
| 59241553 | 1 | < 0.1% |
| 59244454 | 1 | < 0.1% |
| 59243071 | 1 | < 0.1% |
| 59242997 | 1 | < 0.1% |
| 59243070 | 1 | < 0.1% |
| 59247340 | 1 | < 0.1% |
| 59243103 | 1 | < 0.1% |
| 59245851 | 1 | < 0.1% |
| Other values (1163255) | 1163255 |
| Value | Count | Frequency (%) |
| 48536309 | 1 | |
| 48536312 | 1 | |
| 48536313 | 1 | |
| 48536323 | 1 | |
| 48536331 | 1 | |
| 48536868 | 1 | |
| 48536893 | 1 | |
| 48536901 | 1 | |
| 48536945 | 1 | |
| 48537147 | 1 |
| Value | Count | Frequency (%) |
| 59631559 | 1 | |
| 59631556 | 1 | |
| 59631552 | 1 | |
| 59631551 | 1 | |
| 59631550 | 1 | |
| 59631549 | 1 | |
| 59631521 | 1 | |
| 59631518 | 1 | |
| 59631517 | 1 | |
| 59631516 | 1 |
created_date
Date
| Distinct | 1154011 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Minimum | 2021-01-01 00:03:03 |
|---|---|
| Maximum | 2023-12-04 01:28:04 |
closed_date
Date
| Distinct | 1154198 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 190 |
| Missing (%) | < 0.1% |
| Memory size | 8.9 MiB |
| Minimum | 2021-01-01 00:47:09 |
|---|---|
| Maximum | 2023-12-04 01:31:20 |
agency
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| NYPD |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4653060 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NYPD |
|---|---|
| 2nd row | NYPD |
| 3rd row | NYPD |
| 4th row | NYPD |
| 5th row | NYPD |
Common Values
| Value | Count | Frequency (%) |
| NYPD | 1163265 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| nypd | 1163265 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1163265 | |
| Y | 1163265 | |
| P | 1163265 | |
| D | 1163265 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4653060 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1163265 | |
| Y | 1163265 | |
| P | 1163265 | |
| D | 1163265 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4653060 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1163265 | |
| Y | 1163265 | |
| P | 1163265 | |
| D | 1163265 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4653060 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1163265 | |
| Y | 1163265 | |
| P | 1163265 | |
| D | 1163265 |
agency_name
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| New York City Police Department |
|---|
Length
| Max length | 31 |
|---|---|
| Median length | 31 |
| Mean length | 31 |
| Min length | 31 |
Characters and Unicode
| Total characters | 36061215 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York City Police Department |
|---|---|
| 2nd row | New York City Police Department |
| 3rd row | New York City Police Department |
| 4th row | New York City Police Department |
| 5th row | New York City Police Department |
Common Values
| Value | Count | Frequency (%) |
| New York City Police Department | 1163265 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| new | 1163265 | |
| york | 1163265 | |
| city | 1163265 | |
| police | 1163265 | |
| department | 1163265 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4653060 | 12.9% | |
| e | 4653060 | 12.9% |
| t | 3489795 | 9.7% |
| o | 2326530 | 6.5% |
| r | 2326530 | 6.5% |
| i | 2326530 | 6.5% |
| l | 1163265 | 3.2% |
| m | 1163265 | 3.2% |
| a | 1163265 | 3.2% |
| p | 1163265 | 3.2% |
| Other values (10) | 11632650 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 25591830 | |
| Uppercase Letter | 5816325 | 16.1% |
| Space Separator | 4653060 | 12.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4653060 | |
| t | 3489795 | |
| o | 2326530 | |
| r | 2326530 | |
| i | 2326530 | |
| l | 1163265 | 4.5% |
| m | 1163265 | 4.5% |
| a | 1163265 | 4.5% |
| p | 1163265 | 4.5% |
| c | 1163265 | 4.5% |
| Other values (4) | 4653060 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 1163265 | |
| N | 1163265 | |
| P | 1163265 | |
| C | 1163265 | |
| Y | 1163265 |
Space Separator
| Value | Count | Frequency (%) |
| 4653060 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 31408155 | |
| Common | 4653060 | 12.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4653060 | |
| t | 3489795 | 11.1% |
| o | 2326530 | 7.4% |
| r | 2326530 | 7.4% |
| i | 2326530 | 7.4% |
| l | 1163265 | 3.7% |
| m | 1163265 | 3.7% |
| a | 1163265 | 3.7% |
| p | 1163265 | 3.7% |
| D | 1163265 | 3.7% |
| Other values (9) | 10469385 |
Common
| Value | Count | Frequency (%) |
| 4653060 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36061215 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4653060 | 12.9% | |
| e | 4653060 | 12.9% |
| t | 3489795 | 9.7% |
| o | 2326530 | 6.5% |
| r | 2326530 | 6.5% |
| i | 2326530 | 6.5% |
| l | 1163265 | 3.2% |
| m | 1163265 | 3.2% |
| a | 1163265 | 3.2% |
| p | 1163265 | 3.2% |
| Other values (10) | 11632650 |
complaint_type
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Illegal Parking |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 17448975 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Illegal Parking |
|---|---|
| 2nd row | Illegal Parking |
| 3rd row | Illegal Parking |
| 4th row | Illegal Parking |
| 5th row | Illegal Parking |
Common Values
| Value | Count | Frequency (%) |
| Illegal Parking | 1163265 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| illegal | 1163265 | |
| parking | 1163265 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 3489795 | |
| g | 2326530 | |
| a | 2326530 | |
| I | 1163265 | 6.7% |
| e | 1163265 | 6.7% |
| 1163265 | 6.7% | |
| P | 1163265 | 6.7% |
| r | 1163265 | 6.7% |
| k | 1163265 | 6.7% |
| i | 1163265 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 13959180 | |
| Uppercase Letter | 2326530 | 13.3% |
| Space Separator | 1163265 | 6.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 3489795 | |
| g | 2326530 | |
| a | 2326530 | |
| e | 1163265 | 8.3% |
| r | 1163265 | 8.3% |
| k | 1163265 | 8.3% |
| i | 1163265 | 8.3% |
| n | 1163265 | 8.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 1163265 | |
| P | 1163265 |
Space Separator
| Value | Count | Frequency (%) |
| 1163265 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16285710 | |
| Common | 1163265 | 6.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 3489795 | |
| g | 2326530 | |
| a | 2326530 | |
| I | 1163265 | 7.1% |
| e | 1163265 | 7.1% |
| P | 1163265 | 7.1% |
| r | 1163265 | 7.1% |
| k | 1163265 | 7.1% |
| i | 1163265 | 7.1% |
| n | 1163265 | 7.1% |
Common
| Value | Count | Frequency (%) |
| 1163265 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17448975 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 3489795 | |
| g | 2326530 | |
| a | 2326530 | |
| I | 1163265 | 6.7% |
| e | 1163265 | 6.7% |
| 1163265 | 6.7% | |
| P | 1163265 | 6.7% |
| r | 1163265 | 6.7% |
| k | 1163265 | 6.7% |
| i | 1163265 | 6.7% |
descriptor
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Blocked Hydrant | |
|---|---|
| Posted Parking Sign Violation | |
| Blocked Sidewalk | |
| Commercial Overnight Parking | |
| Double Parked Blocking Traffic | |
| Other values (9) |
Length
| Max length | 30 |
|---|---|
| Median length | 29 |
| Mean length | 21.728514 |
| Min length | 15 |
Characters and Unicode
| Total characters | 25276020 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Blocked Hydrant |
|---|---|
| 2nd row | Blocked Hydrant |
| 3rd row | Blocked Hydrant |
| 4th row | Blocked Hydrant |
| 5th row | Blocked Hydrant |
Common Values
| Value | Count | Frequency (%) |
| Blocked Hydrant | 355938 | |
| Posted Parking Sign Violation | 272518 | |
| Blocked Sidewalk | 135647 | 11.7% |
| Commercial Overnight Parking | 102751 | 8.8% |
| Double Parked Blocking Traffic | 70217 | 6.0% |
| Blocked Bike Lane | 60160 | 5.2% |
| Blocked Crosswalk | 51168 | 4.4% |
| Double Parked Blocking Vehicle | 38859 | 3.3% |
| Parking Permit Improper Use | 29506 | 2.5% |
| Paper License Plates | 19102 | 1.6% |
| Other values (4) | 27399 | 2.4% |
Length
| Value | Count | Frequency (%) |
| blocked | 602913 | |
| parking | 404775 | |
| hydrant | 355938 | |
| posted | 272518 | 8.1% |
| sign | 272518 | 8.1% |
| violation | 272518 | 8.1% |
| sidewalk | 135647 | 4.0% |
| commercial | 109724 | 3.3% |
| overnight | 109724 | 3.3% |
| double | 109076 | 3.3% |
| Other values (21) | 708460 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2190546 | 8.7% | |
| i | 1924770 | 7.6% |
| e | 1871628 | 7.4% |
| o | 1860350 | 7.4% |
| a | 1651337 | 6.5% |
| n | 1619906 | 6.4% |
| d | 1496518 | 5.9% |
| k | 1472815 | 5.8% |
| l | 1456329 | 5.8% |
| r | 1362152 | 5.4% |
| Other values (26) | 8369669 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 19731663 | |
| Uppercase Letter | 3353811 | 13.3% |
| Space Separator | 2190546 | 8.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 1924770 | |
| e | 1871628 | |
| o | 1860350 | |
| a | 1651337 | |
| n | 1619906 | |
| d | 1496518 | 7.6% |
| k | 1472815 | 7.5% |
| l | 1456329 | 7.4% |
| r | 1362152 | 6.9% |
| t | 1086705 | 5.5% |
| Other values (13) | 3929153 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 857994 | |
| B | 784329 | |
| S | 415138 | |
| H | 355938 | |
| V | 311377 | 9.3% |
| C | 160892 | 4.8% |
| O | 113639 | 3.4% |
| D | 113407 | 3.4% |
| L | 95357 | 2.8% |
| T | 74548 | 2.2% |
| Other values (2) | 71192 | 2.1% |
Space Separator
| Value | Count | Frequency (%) |
| 2190546 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23085474 | |
| Common | 2190546 | 8.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 1924770 | 8.3% |
| e | 1871628 | 8.1% |
| o | 1860350 | 8.1% |
| a | 1651337 | 7.2% |
| n | 1619906 | 7.0% |
| d | 1496518 | 6.5% |
| k | 1472815 | 6.4% |
| l | 1456329 | 6.3% |
| r | 1362152 | 5.9% |
| t | 1086705 | 4.7% |
| Other values (25) | 7282964 |
Common
| Value | Count | Frequency (%) |
| 2190546 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 25276020 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2190546 | 8.7% | |
| i | 1924770 | 7.6% |
| e | 1871628 | 7.4% |
| o | 1860350 | 7.4% |
| a | 1651337 | 6.5% |
| n | 1619906 | 6.4% |
| d | 1496518 | 5.9% |
| k | 1472815 | 5.8% |
| l | 1456329 | 5.8% |
| r | 1362152 | 5.4% |
| Other values (26) | 8369669 |
location_type
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11886 |
| Missing (%) | 1.0% |
| Memory size | 8.9 MiB |
| Street/Sidewalk |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 17270685 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Street/Sidewalk |
|---|---|
| 2nd row | Street/Sidewalk |
| 3rd row | Street/Sidewalk |
| 4th row | Street/Sidewalk |
| 5th row | Street/Sidewalk |
Common Values
| Value | Count | Frequency (%) |
| Street/Sidewalk | 1151379 | |
| (Missing) | 11886 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| street/sidewalk | 1151379 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3454137 | |
| S | 2302758 | |
| t | 2302758 | |
| r | 1151379 | 6.7% |
| / | 1151379 | 6.7% |
| i | 1151379 | 6.7% |
| d | 1151379 | 6.7% |
| w | 1151379 | 6.7% |
| a | 1151379 | 6.7% |
| l | 1151379 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 13816548 | |
| Uppercase Letter | 2302758 | 13.3% |
| Other Punctuation | 1151379 | 6.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3454137 | |
| t | 2302758 | |
| r | 1151379 | 8.3% |
| i | 1151379 | 8.3% |
| d | 1151379 | 8.3% |
| w | 1151379 | 8.3% |
| a | 1151379 | 8.3% |
| l | 1151379 | 8.3% |
| k | 1151379 | 8.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2302758 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1151379 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16119306 | |
| Common | 1151379 | 6.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3454137 | |
| S | 2302758 | |
| t | 2302758 | |
| r | 1151379 | 7.1% |
| i | 1151379 | 7.1% |
| d | 1151379 | 7.1% |
| w | 1151379 | 7.1% |
| a | 1151379 | 7.1% |
| l | 1151379 | 7.1% |
| k | 1151379 | 7.1% |
Common
| Value | Count | Frequency (%) |
| / | 1151379 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17270685 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3454137 | |
| S | 2302758 | |
| t | 2302758 | |
| r | 1151379 | 6.7% |
| / | 1151379 | 6.7% |
| i | 1151379 | 6.7% |
| d | 1151379 | 6.7% |
| w | 1151379 | 6.7% |
| a | 1151379 | 6.7% |
| l | 1151379 | 6.7% |
incident_zip
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 231 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1208 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10940.354 |
| Minimum | 10000 |
|---|---|
| Maximum | 12345 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10019 |
| Q1 | 10463 |
| median | 11212 |
| Q3 | 11355 |
| 95-th percentile | 11421 |
| Maximum | 12345 |
| Range | 2345 |
| Interquartile range (IQR) | 892 |
Descriptive statistics
| Standard deviation | 501.77467 |
|---|---|
| Coefficient of variation (CV) | 0.045864573 |
| Kurtosis | -0.98870764 |
| Mean | 10940.354 |
| Median Absolute Deviation (MAD) | 163 |
| Skewness | -0.77192328 |
| Sum | 1.2713315 × 1010 |
| Variance | 251777.82 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11385 | 33965 | 2.9% |
| 11201 | 28724 | 2.5% |
| 10468 | 22371 | 1.9% |
| 11378 | 19518 | 1.7% |
| 11101 | 18430 | 1.6% |
| 11214 | 16823 | 1.4% |
| 11205 | 16127 | 1.4% |
| 11208 | 15750 | 1.4% |
| 11230 | 15622 | 1.3% |
| 11223 | 15341 | 1.3% |
| Other values (221) | 959386 |
| Value | Count | Frequency (%) |
| 10000 | 49 | < 0.1% |
| 10001 | 4476 | |
| 10002 | 9451 | |
| 10003 | 3856 | |
| 10004 | 1220 | 0.1% |
| 10005 | 565 | < 0.1% |
| 10006 | 788 | 0.1% |
| 10007 | 2252 | 0.2% |
| 10009 | 4382 | |
| 10010 | 1842 | 0.2% |
| Value | Count | Frequency (%) |
| 12345 | 24 | < 0.1% |
| 11697 | 51 | < 0.1% |
| 11695 | 3 | < 0.1% |
| 11694 | 6011 | |
| 11693 | 3002 | |
| 11692 | 846 | 0.1% |
| 11691 | 3386 | |
| 11436 | 3004 | |
| 11435 | 5846 | |
| 11434 | 5255 |
incident_address
Text
| Distinct | 260910 |
|---|---|
| Distinct (%) | 22.5% |
| Missing | 1183 |
| Missing (%) | 0.1% |
| Memory size | 8.9 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 34 |
| Mean length | 17.454932 |
| Min length | 3 |
Characters and Unicode
| Total characters | 20284062 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 142618 ? |
|---|---|
| Unique (%) | 12.3% |
Sample
| 1st row | 8700 23 AVENUE |
|---|---|
| 2nd row | 69-41 64 STREET |
| 3rd row | 69-23 64 STREET |
| 4th row | 64 STREET |
| 5th row | 1577 LELAND AVENUE |
| Value | Count | Frequency (%) |
| street | 534721 | 14.6% |
| avenue | 417626 | 11.4% |
| east | 94884 | 2.6% |
| west | 78841 | 2.2% |
| place | 48539 | 1.3% |
| boulevard | 39943 | 1.1% |
| road | 39797 | 1.1% |
| parkway | 13764 | 0.4% |
| drive | 12633 | 0.3% |
| grand | 12060 | 0.3% |
| Other values (28010) | 2360161 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2781421 | 13.7% | |
| E | 2702884 | 13.3% |
| T | 1543891 | 7.6% |
| A | 1107709 | 5.5% |
| R | 1090169 | 5.4% |
| S | 993814 | 4.9% |
| 1 | 910498 | 4.5% |
| N | 859748 | 4.2% |
| 2 | 624439 | 3.1% |
| U | 587934 | 2.9% |
| Other values (32) | 7081555 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12349238 | |
| Decimal Number | 4849589 | 23.9% |
| Space Separator | 2781421 | 13.7% |
| Dash Punctuation | 303474 | 1.5% |
| Other Punctuation | 338 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2702884 | |
| T | 1543891 | |
| A | 1107709 | |
| R | 1090169 | |
| S | 993814 | 8.0% |
| N | 859748 | 7.0% |
| U | 587934 | 4.8% |
| V | 528012 | 4.3% |
| O | 479392 | 3.9% |
| L | 366555 | 3.0% |
| Other values (16) | 2089130 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 910498 | |
| 2 | 624439 | |
| 3 | 498228 | |
| 0 | 492599 | |
| 5 | 473540 | |
| 4 | 440413 | |
| 6 | 378994 | |
| 7 | 369157 | |
| 8 | 333683 | 6.9% |
| 9 | 328038 | 6.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 210 | |
| ' | 128 |
Space Separator
| Value | Count | Frequency (%) |
| 2781421 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 303474 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12349238 | |
| Common | 7934824 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2702884 | |
| T | 1543891 | |
| A | 1107709 | |
| R | 1090169 | |
| S | 993814 | 8.0% |
| N | 859748 | 7.0% |
| U | 587934 | 4.8% |
| V | 528012 | 4.3% |
| O | 479392 | 3.9% |
| L | 366555 | 3.0% |
| Other values (16) | 2089130 |
Common
| Value | Count | Frequency (%) |
| 2781421 | ||
| 1 | 910498 | 11.5% |
| 2 | 624439 | 7.9% |
| 3 | 498228 | 6.3% |
| 0 | 492599 | 6.2% |
| 5 | 473540 | 6.0% |
| 4 | 440413 | 5.6% |
| 6 | 378994 | 4.8% |
| 7 | 369157 | 4.7% |
| 8 | 333683 | 4.2% |
| Other values (6) | 631852 | 8.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20284062 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2781421 | 13.7% | |
| E | 2702884 | 13.3% |
| T | 1543891 | 7.6% |
| A | 1107709 | 5.5% |
| R | 1090169 | 5.4% |
| S | 993814 | 4.9% |
| 1 | 910498 | 4.5% |
| N | 859748 | 4.2% |
| 2 | 624439 | 3.1% |
| U | 587934 | 2.9% |
| Other values (32) | 7081555 |
street_name
Text
| Distinct | 8069 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 1183 |
| Missing (%) | 0.1% |
| Memory size | 8.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.029777 |
| Min length | 3 |
Characters and Unicode
| Total characters | 15141669 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1228 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 23 AVENUE |
|---|---|
| 2nd row | 64 STREET |
| 3rd row | 64 STREET |
| 4th row | 64 STREET |
| 5th row | LELAND AVENUE |
| Value | Count | Frequency (%) |
| street | 534721 | |
| avenue | 417626 | 16.2% |
| east | 94884 | 3.7% |
| west | 78841 | 3.1% |
| place | 48539 | 1.9% |
| boulevard | 39943 | 1.6% |
| road | 39797 | 1.5% |
| parkway | 13764 | 0.5% |
| drive | 12633 | 0.5% |
| grand | 12060 | 0.5% |
| Other values (4511) | 1282014 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2702394 | |
| 1703274 | ||
| T | 1543874 | |
| A | 1104984 | 7.3% |
| R | 1090146 | 7.2% |
| S | 993795 | 6.6% |
| N | 859728 | 5.7% |
| U | 587934 | 3.9% |
| V | 528006 | 3.5% |
| O | 479349 | 3.2% |
| Other values (31) | 3548185 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12344397 | |
| Space Separator | 1703274 | 11.2% |
| Decimal Number | 1093777 | 7.2% |
| Other Punctuation | 128 | < 0.1% |
| Dash Punctuation | 91 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2702394 | |
| T | 1543874 | |
| A | 1104984 | |
| R | 1090146 | |
| S | 993795 | 8.1% |
| N | 859728 | 7.0% |
| U | 587934 | 4.8% |
| V | 528006 | 4.3% |
| O | 479349 | 3.9% |
| L | 366549 | 3.0% |
| Other values (16) | 2087638 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 220164 | |
| 2 | 128323 | |
| 3 | 110593 | |
| 7 | 100729 | |
| 6 | 98942 | |
| 5 | 94950 | |
| 4 | 91415 | |
| 8 | 88211 | |
| 9 | 85791 | 7.8% |
| 0 | 74659 | 6.8% |
Space Separator
| Value | Count | Frequency (%) |
| 1703274 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 128 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 91 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12344397 | |
| Common | 2797272 | 18.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2702394 | |
| T | 1543874 | |
| A | 1104984 | |
| R | 1090146 | |
| S | 993795 | 8.1% |
| N | 859728 | 7.0% |
| U | 587934 | 4.8% |
| V | 528006 | 4.3% |
| O | 479349 | 3.9% |
| L | 366549 | 3.0% |
| Other values (16) | 2087638 |
Common
| Value | Count | Frequency (%) |
| 1703274 | ||
| 1 | 220164 | 7.9% |
| 2 | 128323 | 4.6% |
| 3 | 110593 | 4.0% |
| 7 | 100729 | 3.6% |
| 6 | 98942 | 3.5% |
| 5 | 94950 | 3.4% |
| 4 | 91415 | 3.3% |
| 8 | 88211 | 3.2% |
| 9 | 85791 | 3.1% |
| Other values (5) | 74880 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15141669 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2702394 | |
| 1703274 | ||
| T | 1543874 | |
| A | 1104984 | 7.3% |
| R | 1090146 | 7.2% |
| S | 993795 | 6.6% |
| N | 859728 | 5.7% |
| U | 587934 | 3.9% |
| V | 528006 | 3.5% |
| O | 479349 | 3.2% |
| Other values (31) | 3548185 |
cross_street_1
Text
| Distinct | 8587 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 2653 |
| Missing (%) | 0.2% |
| Memory size | 8.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 12.8733 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14940906 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1042 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BENSON AVENUE |
|---|---|
| 2nd row | CATALPA AVENUE |
| 3rd row | CATALPA AVENUE |
| 4th row | 64 STREET |
| 5th row | GUERLAIN STREET |
| Value | Count | Frequency (%) |
| avenue | 524462 | 20.2% |
| street | 391271 | 15.1% |
| east | 81211 | 3.1% |
| west | 61523 | 2.4% |
| road | 45516 | 1.8% |
| place | 44550 | 1.7% |
| boulevard | 35770 | 1.4% |
| 5 | 13995 | 0.5% |
| park | 13841 | 0.5% |
| way | 13840 | 0.5% |
| Other values (5429) | 1372414 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2609486 | |
| 1644752 | ||
| A | 1258359 | 8.4% |
| T | 1245884 | 8.3% |
| N | 977036 | 6.5% |
| R | 946319 | 6.3% |
| S | 824252 | 5.5% |
| U | 688577 | 4.6% |
| V | 616504 | 4.1% |
| O | 476561 | 3.2% |
| Other values (33) | 3653176 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12247302 | |
| Space Separator | 1644752 | 11.0% |
| Decimal Number | 1044823 | 7.0% |
| Dash Punctuation | 2562 | < 0.1% |
| Other Punctuation | 1437 | < 0.1% |
| Open Punctuation | 15 | < 0.1% |
| Close Punctuation | 15 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2609486 | |
| A | 1258359 | |
| T | 1245884 | |
| N | 977036 | 8.0% |
| R | 946319 | 7.7% |
| S | 824252 | 6.7% |
| U | 688577 | 5.6% |
| V | 616504 | 5.0% |
| O | 476561 | 3.9% |
| L | 403097 | 3.3% |
| Other values (16) | 2201227 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 220192 | |
| 2 | 124042 | |
| 3 | 101440 | |
| 7 | 93359 | |
| 5 | 92056 | |
| 6 | 90524 | |
| 8 | 85015 | 8.1% |
| 4 | 83839 | 8.0% |
| 0 | 77594 | 7.4% |
| 9 | 76762 | 7.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 694 | |
| ' | 691 | |
| & | 52 | 3.6% |
Space Separator
| Value | Count | Frequency (%) |
| 1644752 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2562 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 15 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 15 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12247302 | |
| Common | 2693604 | 18.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2609486 | |
| A | 1258359 | |
| T | 1245884 | |
| N | 977036 | 8.0% |
| R | 946319 | 7.7% |
| S | 824252 | 6.7% |
| U | 688577 | 5.6% |
| V | 616504 | 5.0% |
| O | 476561 | 3.9% |
| L | 403097 | 3.3% |
| Other values (16) | 2201227 |
Common
| Value | Count | Frequency (%) |
| 1644752 | ||
| 1 | 220192 | 8.2% |
| 2 | 124042 | 4.6% |
| 3 | 101440 | 3.8% |
| 7 | 93359 | 3.5% |
| 5 | 92056 | 3.4% |
| 6 | 90524 | 3.4% |
| 8 | 85015 | 3.2% |
| 4 | 83839 | 3.1% |
| 0 | 77594 | 2.9% |
| Other values (7) | 80791 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14940906 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2609486 | |
| 1644752 | ||
| A | 1258359 | 8.4% |
| T | 1245884 | 8.3% |
| N | 977036 | 6.5% |
| R | 946319 | 6.3% |
| S | 824252 | 5.5% |
| U | 688577 | 4.6% |
| V | 616504 | 4.1% |
| O | 476561 | 3.2% |
| Other values (33) | 3653176 |
cross_street_2
Text
| Distinct | 8730 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1992 |
| Missing (%) | 0.2% |
| Memory size | 8.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.137392 |
| Min length | 3 |
Characters and Unicode
| Total characters | 15256099 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1043 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BATH AVENUE |
|---|---|
| 2nd row | SHALER AVENUE |
| 3rd row | SHALER AVENUE |
| 4th row | SHALER AVENUE |
| 5th row | EAST TREMONT AVENUE |
| Value | Count | Frequency (%) |
| avenue | 520902 | 19.9% |
| street | 384473 | 14.7% |
| east | 81388 | 3.1% |
| west | 60862 | 2.3% |
| road | 49570 | 1.9% |
| place | 44396 | 1.7% |
| boulevard | 41628 | 1.6% |
| end | 14982 | 0.6% |
| drive | 13932 | 0.5% |
| dead | 13556 | 0.5% |
| Other values (5495) | 1389016 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2645418 | |
| 1664653 | ||
| T | 1253491 | 8.2% |
| A | 1249377 | 8.2% |
| N | 1004665 | 6.6% |
| R | 983565 | 6.4% |
| S | 827156 | 5.4% |
| U | 706147 | 4.6% |
| V | 640384 | 4.2% |
| O | 532151 | 3.5% |
| Other values (33) | 3749092 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12591932 | |
| Space Separator | 1664653 | 10.9% |
| Decimal Number | 995560 | 6.5% |
| Dash Punctuation | 2461 | < 0.1% |
| Other Punctuation | 1461 | < 0.1% |
| Open Punctuation | 16 | < 0.1% |
| Close Punctuation | 16 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2645418 | |
| T | 1253491 | |
| A | 1249377 | |
| N | 1004665 | 8.0% |
| R | 983565 | 7.8% |
| S | 827156 | 6.6% |
| U | 706147 | 5.6% |
| V | 640384 | 5.1% |
| O | 532151 | 4.2% |
| L | 436700 | 3.5% |
| Other values (16) | 2312878 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 219344 | |
| 2 | 122328 | |
| 3 | 99528 | |
| 5 | 85915 | 8.6% |
| 7 | 85542 | 8.6% |
| 6 | 83568 | 8.4% |
| 4 | 82339 | 8.3% |
| 8 | 78632 | 7.9% |
| 9 | 69935 | 7.0% |
| 0 | 68429 | 6.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 717 | |
| ' | 699 | |
| & | 45 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1664653 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2461 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 16 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 16 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12591932 | |
| Common | 2664167 | 17.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2645418 | |
| T | 1253491 | |
| A | 1249377 | |
| N | 1004665 | 8.0% |
| R | 983565 | 7.8% |
| S | 827156 | 6.6% |
| U | 706147 | 5.6% |
| V | 640384 | 5.1% |
| O | 532151 | 4.2% |
| L | 436700 | 3.5% |
| Other values (16) | 2312878 |
Common
| Value | Count | Frequency (%) |
| 1664653 | ||
| 1 | 219344 | 8.2% |
| 2 | 122328 | 4.6% |
| 3 | 99528 | 3.7% |
| 5 | 85915 | 3.2% |
| 7 | 85542 | 3.2% |
| 6 | 83568 | 3.1% |
| 4 | 82339 | 3.1% |
| 8 | 78632 | 3.0% |
| 9 | 69935 | 2.6% |
| Other values (7) | 72383 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15256099 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2645418 | |
| 1664653 | ||
| T | 1253491 | 8.2% |
| A | 1249377 | 8.2% |
| N | 1004665 | 6.6% |
| R | 983565 | 6.4% |
| S | 827156 | 5.4% |
| U | 706147 | 4.6% |
| V | 640384 | 4.2% |
| O | 532151 | 3.5% |
| Other values (33) | 3749092 |
| Distinct | 8587 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 2653 |
| Missing (%) | 0.2% |
| Memory size | 8.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 12.8733 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14940906 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1042 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BENSON AVENUE |
|---|---|
| 2nd row | CATALPA AVENUE |
| 3rd row | CATALPA AVENUE |
| 4th row | 64 STREET |
| 5th row | GUERLAIN STREET |
| Value | Count | Frequency (%) |
| avenue | 524462 | 20.2% |
| street | 391271 | 15.1% |
| east | 81211 | 3.1% |
| west | 61523 | 2.4% |
| road | 45516 | 1.8% |
| place | 44550 | 1.7% |
| boulevard | 35770 | 1.4% |
| 5 | 13995 | 0.5% |
| park | 13841 | 0.5% |
| way | 13840 | 0.5% |
| Other values (5429) | 1372414 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2609486 | |
| 1644752 | ||
| A | 1258359 | 8.4% |
| T | 1245884 | 8.3% |
| N | 977036 | 6.5% |
| R | 946319 | 6.3% |
| S | 824252 | 5.5% |
| U | 688577 | 4.6% |
| V | 616504 | 4.1% |
| O | 476561 | 3.2% |
| Other values (33) | 3653176 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12247302 | |
| Space Separator | 1644752 | 11.0% |
| Decimal Number | 1044823 | 7.0% |
| Dash Punctuation | 2562 | < 0.1% |
| Other Punctuation | 1437 | < 0.1% |
| Open Punctuation | 15 | < 0.1% |
| Close Punctuation | 15 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2609486 | |
| A | 1258359 | |
| T | 1245884 | |
| N | 977036 | 8.0% |
| R | 946319 | 7.7% |
| S | 824252 | 6.7% |
| U | 688577 | 5.6% |
| V | 616504 | 5.0% |
| O | 476561 | 3.9% |
| L | 403097 | 3.3% |
| Other values (16) | 2201227 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 220192 | |
| 2 | 124042 | |
| 3 | 101440 | |
| 7 | 93359 | |
| 5 | 92056 | |
| 6 | 90524 | |
| 8 | 85015 | 8.1% |
| 4 | 83839 | 8.0% |
| 0 | 77594 | 7.4% |
| 9 | 76762 | 7.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 694 | |
| ' | 691 | |
| & | 52 | 3.6% |
Space Separator
| Value | Count | Frequency (%) |
| 1644752 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2562 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 15 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 15 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12247302 | |
| Common | 2693604 | 18.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2609486 | |
| A | 1258359 | |
| T | 1245884 | |
| N | 977036 | 8.0% |
| R | 946319 | 7.7% |
| S | 824252 | 6.7% |
| U | 688577 | 5.6% |
| V | 616504 | 5.0% |
| O | 476561 | 3.9% |
| L | 403097 | 3.3% |
| Other values (16) | 2201227 |
Common
| Value | Count | Frequency (%) |
| 1644752 | ||
| 1 | 220192 | 8.2% |
| 2 | 124042 | 4.6% |
| 3 | 101440 | 3.8% |
| 7 | 93359 | 3.5% |
| 5 | 92056 | 3.4% |
| 6 | 90524 | 3.4% |
| 8 | 85015 | 3.2% |
| 4 | 83839 | 3.1% |
| 0 | 77594 | 2.9% |
| Other values (7) | 80791 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14940906 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2609486 | |
| 1644752 | ||
| A | 1258359 | 8.4% |
| T | 1245884 | 8.3% |
| N | 977036 | 6.5% |
| R | 946319 | 6.3% |
| S | 824252 | 5.5% |
| U | 688577 | 4.6% |
| V | 616504 | 4.1% |
| O | 476561 | 3.2% |
| Other values (33) | 3653176 |
| Distinct | 8730 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1992 |
| Missing (%) | 0.2% |
| Memory size | 8.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.137392 |
| Min length | 3 |
Characters and Unicode
| Total characters | 15256099 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1043 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BATH AVENUE |
|---|---|
| 2nd row | SHALER AVENUE |
| 3rd row | SHALER AVENUE |
| 4th row | SHALER AVENUE |
| 5th row | EAST TREMONT AVENUE |
| Value | Count | Frequency (%) |
| avenue | 520902 | 19.9% |
| street | 384473 | 14.7% |
| east | 81388 | 3.1% |
| west | 60862 | 2.3% |
| road | 49570 | 1.9% |
| place | 44396 | 1.7% |
| boulevard | 41628 | 1.6% |
| end | 14982 | 0.6% |
| drive | 13932 | 0.5% |
| dead | 13556 | 0.5% |
| Other values (5495) | 1389016 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2645418 | |
| 1664653 | ||
| T | 1253491 | 8.2% |
| A | 1249377 | 8.2% |
| N | 1004665 | 6.6% |
| R | 983565 | 6.4% |
| S | 827156 | 5.4% |
| U | 706147 | 4.6% |
| V | 640384 | 4.2% |
| O | 532151 | 3.5% |
| Other values (33) | 3749092 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12591932 | |
| Space Separator | 1664653 | 10.9% |
| Decimal Number | 995560 | 6.5% |
| Dash Punctuation | 2461 | < 0.1% |
| Other Punctuation | 1461 | < 0.1% |
| Open Punctuation | 16 | < 0.1% |
| Close Punctuation | 16 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2645418 | |
| T | 1253491 | |
| A | 1249377 | |
| N | 1004665 | 8.0% |
| R | 983565 | 7.8% |
| S | 827156 | 6.6% |
| U | 706147 | 5.6% |
| V | 640384 | 5.1% |
| O | 532151 | 4.2% |
| L | 436700 | 3.5% |
| Other values (16) | 2312878 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 219344 | |
| 2 | 122328 | |
| 3 | 99528 | |
| 5 | 85915 | 8.6% |
| 7 | 85542 | 8.6% |
| 6 | 83568 | 8.4% |
| 4 | 82339 | 8.3% |
| 8 | 78632 | 7.9% |
| 9 | 69935 | 7.0% |
| 0 | 68429 | 6.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 717 | |
| ' | 699 | |
| & | 45 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1664653 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2461 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 16 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 16 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12591932 | |
| Common | 2664167 | 17.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2645418 | |
| T | 1253491 | |
| A | 1249377 | |
| N | 1004665 | 8.0% |
| R | 983565 | 7.8% |
| S | 827156 | 6.6% |
| U | 706147 | 5.6% |
| V | 640384 | 5.1% |
| O | 532151 | 4.2% |
| L | 436700 | 3.5% |
| Other values (16) | 2312878 |
Common
| Value | Count | Frequency (%) |
| 1664653 | ||
| 1 | 219344 | 8.2% |
| 2 | 122328 | 4.6% |
| 3 | 99528 | 3.7% |
| 5 | 85915 | 3.2% |
| 7 | 85542 | 3.2% |
| 6 | 83568 | 3.1% |
| 4 | 82339 | 3.1% |
| 8 | 78632 | 3.0% |
| 9 | 69935 | 2.6% |
| Other values (7) | 72383 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15256099 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2645418 | |
| 1664653 | ||
| T | 1253491 | 8.2% |
| A | 1249377 | 8.2% |
| N | 1004665 | 6.6% |
| R | 983565 | 6.4% |
| S | 827156 | 5.4% |
| U | 706147 | 4.6% |
| V | 640384 | 4.2% |
| O | 532151 | 3.5% |
| Other values (33) | 3749092 |
address_type
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 215156 |
| Missing (%) | 18.5% |
| Memory size | 8.9 MiB |
| ADDRESS | |
|---|---|
| INTERSECTION | 59672 |
| BLOCKFACE | 6630 |
| UNRECOGNIZED | 1200 |
Length
| Max length | 12 |
|---|---|
| Median length | 7 |
| Mean length | 7.3350037 |
| Min length | 7 |
Characters and Unicode
| Total characters | 6954383 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ADDRESS |
|---|---|
| 2nd row | ADDRESS |
| 3rd row | ADDRESS |
| 4th row | INTERSECTION |
| 5th row | ADDRESS |
Common Values
| Value | Count | Frequency (%) |
| ADDRESS | 880607 | |
| INTERSECTION | 59672 | 5.1% |
| BLOCKFACE | 6630 | 0.6% |
| UNRECOGNIZED | 1200 | 0.1% |
| (Missing) | 215156 | 18.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| address | 880607 | |
| intersection | 59672 | 6.3% |
| blockface | 6630 | 0.7% |
| unrecognized | 1200 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 1820886 | |
| D | 1762414 | |
| E | 1008981 | |
| R | 941479 | |
| A | 887237 | |
| N | 121744 | 1.8% |
| I | 120544 | 1.7% |
| T | 119344 | 1.7% |
| C | 74132 | 1.1% |
| O | 67502 | 1.0% |
| Other values (7) | 30120 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6954383 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1820886 | |
| D | 1762414 | |
| E | 1008981 | |
| R | 941479 | |
| A | 887237 | |
| N | 121744 | 1.8% |
| I | 120544 | 1.7% |
| T | 119344 | 1.7% |
| C | 74132 | 1.1% |
| O | 67502 | 1.0% |
| Other values (7) | 30120 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6954383 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 1820886 | |
| D | 1762414 | |
| E | 1008981 | |
| R | 941479 | |
| A | 887237 | |
| N | 121744 | 1.8% |
| I | 120544 | 1.7% |
| T | 119344 | 1.7% |
| C | 74132 | 1.1% |
| O | 67502 | 1.0% |
| Other values (7) | 30120 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6954383 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 1820886 | |
| D | 1762414 | |
| E | 1008981 | |
| R | 941479 | |
| A | 887237 | |
| N | 121744 | 1.8% |
| I | 120544 | 1.7% |
| T | 119344 | 1.7% |
| C | 74132 | 1.1% |
| O | 67502 | 1.0% |
| Other values (7) | 30120 | 0.4% |
city
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 49 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 83650 |
| Missing (%) | 7.2% |
| Memory size | 8.9 MiB |
| BROOKLYN | |
|---|---|
| BRONX | |
| NEW YORK | |
| RIDGEWOOD | 31234 |
| STATEN ISLAND | 29233 |
| Other values (44) |
Length
| Max length | 19 |
|---|---|
| Median length | 8 |
| Mean length | 8.3471821 |
| Min length | 5 |
Characters and Unicode
| Total characters | 9011743 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | RIDGEWOOD |
| 3rd row | RIDGEWOOD |
| 4th row | BRONX |
| 5th row | BROOKLYN |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 395150 | |
| BRONX | 181092 | |
| NEW YORK | 153502 | 13.2% |
| RIDGEWOOD | 31234 | 2.7% |
| STATEN ISLAND | 29233 | 2.5% |
| ASTORIA | 27850 | 2.4% |
| LONG ISLAND CITY | 19238 | 1.7% |
| MASPETH | 18436 | 1.6% |
| JAMAICA | 18227 | 1.6% |
| FLUSHING | 14643 | 1.3% |
| Other values (39) | 191010 | |
| (Missing) | 83650 | 7.2% |
Length
| Value | Count | Frequency (%) |
| brooklyn | 395151 | |
| bronx | 181093 | |
| new | 153687 | 10.7% |
| york | 153503 | 10.7% |
| island | 48471 | 3.4% |
| ridgewood | 31234 | 2.2% |
| staten | 29233 | 2.0% |
| astoria | 27850 | 1.9% |
| park | 24472 | 1.7% |
| elmhurst | 21210 | 1.5% |
| Other values (51) | 373522 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 1437869 | |
| N | 948379 | |
| R | 925816 | |
| L | 616739 | 6.8% |
| K | 598666 | 6.6% |
| B | 592194 | 6.6% |
| Y | 588931 | 6.5% |
| E | 448406 | 5.0% |
| A | 376539 | 4.2% |
| 359811 | 4.0% | |
| Other values (26) | 2118393 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 8651916 | |
| Space Separator | 359811 | 4.0% |
| Lowercase Letter | 16 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1437869 | |
| N | 948379 | |
| R | 925816 | |
| L | 616739 | 7.1% |
| K | 598666 | 6.9% |
| B | 592194 | 6.8% |
| Y | 588931 | 6.8% |
| E | 448406 | 5.2% |
| A | 376539 | 4.4% |
| S | 287861 | 3.3% |
| Other values (16) | 1830516 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 4 | |
| r | 3 | |
| n | 2 | |
| k | 2 | |
| x | 1 | 6.2% |
| l | 1 | 6.2% |
| y | 1 | 6.2% |
| e | 1 | 6.2% |
| w | 1 | 6.2% |
Space Separator
| Value | Count | Frequency (%) |
| 359811 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8651932 | |
| Common | 359811 | 4.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 1437869 | |
| N | 948379 | |
| R | 925816 | |
| L | 616739 | 7.1% |
| K | 598666 | 6.9% |
| B | 592194 | 6.8% |
| Y | 588931 | 6.8% |
| E | 448406 | 5.2% |
| A | 376539 | 4.4% |
| S | 287861 | 3.3% |
| Other values (25) | 1830532 |
Common
| Value | Count | Frequency (%) |
| 359811 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9011743 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 1437869 | |
| N | 948379 | |
| R | 925816 | |
| L | 616739 | 6.8% |
| K | 598666 | 6.6% |
| B | 592194 | 6.6% |
| Y | 588931 | 6.5% |
| E | 448406 | 5.0% |
| A | 376539 | 4.2% |
| 359811 | 4.0% | |
| Other values (26) | 2118393 |
landmark
Text
MISSING 
| Distinct | 6979 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 83662 |
| Missing (%) | 7.2% |
| Memory size | 8.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.043666 |
| Min length | 6 |
Characters and Unicode
| Total characters | 14081981 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 882 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 23 AVENUE |
|---|---|
| 2nd row | 64 STREET |
| 3rd row | 64 STREET |
| 4th row | LELAND AVENUE |
| 5th row | VAN SICLEN AVENUE |
| Value | Count | Frequency (%) |
| street | 505299 | |
| avenue | 382776 | 16.0% |
| east | 88123 | 3.7% |
| west | 76404 | 3.2% |
| place | 43472 | 1.8% |
| boulevard | 37967 | 1.6% |
| road | 36096 | 1.5% |
| parkway | 13432 | 0.6% |
| drive | 11674 | 0.5% |
| park | 11630 | 0.5% |
| Other values (4036) | 1191810 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2520033 | |
| 1603320 | ||
| T | 1449789 | |
| A | 1021588 | 7.3% |
| R | 1018025 | 7.2% |
| S | 934528 | 6.6% |
| N | 793516 | 5.6% |
| U | 540603 | 3.8% |
| V | 485807 | 3.4% |
| O | 443964 | 3.2% |
| Other values (33) | 3270808 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11461069 | |
| Space Separator | 1603320 | 11.4% |
| Decimal Number | 1017353 | 7.2% |
| Other Punctuation | 151 | < 0.1% |
| Dash Punctuation | 86 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2520033 | |
| T | 1449789 | |
| A | 1021588 | |
| R | 1018025 | |
| S | 934528 | 8.2% |
| N | 793516 | 6.9% |
| U | 540603 | 4.7% |
| V | 485807 | 4.2% |
| O | 443964 | 3.9% |
| L | 337697 | 2.9% |
| Other values (16) | 1915519 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 202516 | |
| 2 | 120227 | |
| 3 | 103726 | |
| 7 | 94597 | |
| 6 | 90837 | |
| 5 | 89273 | |
| 4 | 85698 | |
| 8 | 81930 | |
| 9 | 80071 | 7.9% |
| 0 | 68478 | 6.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 149 | |
| / | 1 | 0.7% |
| & | 1 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 1603320 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 86 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11461069 | |
| Common | 2620912 | 18.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2520033 | |
| T | 1449789 | |
| A | 1021588 | |
| R | 1018025 | |
| S | 934528 | 8.2% |
| N | 793516 | 6.9% |
| U | 540603 | 4.7% |
| V | 485807 | 4.2% |
| O | 443964 | 3.9% |
| L | 337697 | 2.9% |
| Other values (16) | 1915519 |
Common
| Value | Count | Frequency (%) |
| 1603320 | ||
| 1 | 202516 | 7.7% |
| 2 | 120227 | 4.6% |
| 3 | 103726 | 4.0% |
| 7 | 94597 | 3.6% |
| 6 | 90837 | 3.5% |
| 5 | 89273 | 3.4% |
| 4 | 85698 | 3.3% |
| 8 | 81930 | 3.1% |
| 9 | 80071 | 3.1% |
| Other values (7) | 68717 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14081981 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2520033 | |
| 1603320 | ||
| T | 1449789 | |
| A | 1021588 | 7.3% |
| R | 1018025 | 7.2% |
| S | 934528 | 6.6% |
| N | 793516 | 5.6% |
| U | 540603 | 3.8% |
| V | 485807 | 3.4% |
| O | 443964 | 3.2% |
| Other values (33) | 3270808 |
status
Categorical
IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Closed | |
|---|---|
| In Progress | 190 |
| Unspecified | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.0008596 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6980590 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Closed |
|---|---|
| 2nd row | Closed |
| 3rd row | Closed |
| 4th row | Closed |
| 5th row | Closed |
Common Values
| Value | Count | Frequency (%) |
| Closed | 1163065 | |
| In Progress | 190 | < 0.1% |
| Unspecified | 10 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| closed | 1163065 | |
| in | 190 | < 0.1% |
| progress | 190 | < 0.1% |
| unspecified | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 1163455 | |
| e | 1163275 | |
| o | 1163255 | |
| d | 1163075 | |
| C | 1163065 | |
| l | 1163065 | |
| r | 380 | < 0.1% |
| n | 200 | < 0.1% |
| g | 190 | < 0.1% |
| 190 | < 0.1% | |
| Other values (7) | 440 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5816945 | |
| Uppercase Letter | 1163455 | 16.7% |
| Space Separator | 190 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 1163455 | |
| e | 1163275 | |
| o | 1163255 | |
| d | 1163075 | |
| l | 1163065 | |
| r | 380 | < 0.1% |
| n | 200 | < 0.1% |
| g | 190 | < 0.1% |
| i | 20 | < 0.1% |
| p | 10 | < 0.1% |
| Other values (2) | 20 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1163065 | |
| P | 190 | < 0.1% |
| I | 190 | < 0.1% |
| U | 10 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 190 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6980400 | |
| Common | 190 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 1163455 | |
| e | 1163275 | |
| o | 1163255 | |
| d | 1163075 | |
| C | 1163065 | |
| l | 1163065 | |
| r | 380 | < 0.1% |
| n | 200 | < 0.1% |
| g | 190 | < 0.1% |
| P | 190 | < 0.1% |
| Other values (6) | 250 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 190 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6980590 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 1163455 | |
| e | 1163275 | |
| o | 1163255 | |
| d | 1163075 | |
| C | 1163065 | |
| l | 1163065 | |
| r | 380 | < 0.1% |
| n | 200 | < 0.1% |
| g | 190 | < 0.1% |
| 190 | < 0.1% | |
| Other values (7) | 440 | < 0.1% |
resolution_description
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 239 |
| Missing (%) | < 0.1% |
| Memory size | 8.9 MiB |
| The Police Department responded to the complaint and took action to fix the condition. | |
|---|---|
| The Police Department issued a summons in response to the complaint. | |
| The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. | |
| The Police Department responded to the complaint and determined that police action was not necessary. | |
| The Police Department responded and upon arrival those responsible for the condition were gone. | |
| Other values (7) |
Length
| Max length | 185 |
|---|---|
| Median length | 109 |
| Mean length | 95.796437 |
| Min length | 66 |
Characters and Unicode
| Total characters | 111413747 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. |
|---|---|
| 2nd row | The Police Department issued a summons in response to the complaint. |
| 3rd row | The Police Department issued a summons in response to the complaint. |
| 4th row | The Police Department issued a summons in response to the complaint. |
| 5th row | The Police Department responded to the complaint and took action to fix the condition. |
Common Values
| Value | Count | Frequency (%) |
| The Police Department responded to the complaint and took action to fix the condition. | 282696 | |
| The Police Department issued a summons in response to the complaint. | 213132 | |
| The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. | 207689 | |
| The Police Department responded to the complaint and determined that police action was not necessary. | 199664 | |
| The Police Department responded and upon arrival those responsible for the condition were gone. | 197414 | |
| The Police Department reviewed your complaint and provided additional information below. | 34988 | 3.0% |
| This complaint does not fall under the Police Department's jurisdiction. | 20525 | 1.8% |
| Your request can not be processed at this time because of insufficient contact information. Please create a new Service Request on NYC.gov and provide more detailed contact information. | 5101 | 0.4% |
| The Police Department responded to the complaint and a report was prepared. | 1251 | 0.1% |
| The Police Department responded to the complaint but officers were unable to gain entry into the premises. | 438 | < 0.1% |
| Other values (2) | 128 | < 0.1% |
| (Missing) | 239 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| the | 2958817 | |
| police | 1357589 | 7.9% |
| to | 1188100 | 6.9% |
| department | 1137400 | 6.6% |
| complaint | 960511 | 5.6% |
| and | 928835 | 5.4% |
| responded | 889152 | 5.2% |
| action | 482360 | 2.8% |
| condition | 480110 | 2.8% |
| that | 407353 | 2.4% |
| Other values (73) | 6389166 |
Most occurring characters
| Value | Count | Frequency (%) |
| 16016367 | ||
| e | 13022254 | |
| t | 10171267 | 9.1% |
| o | 9815413 | 8.8% |
| n | 8477997 | 7.6% |
| i | 7080956 | 6.4% |
| a | 6377179 | 5.7% |
| d | 4473449 | 4.0% |
| r | 4296068 | 3.9% |
| p | 3864689 | 3.5% |
| Other values (26) | 27818108 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 90694145 | |
| Space Separator | 16016367 | 14.4% |
| Uppercase Letter | 3509482 | 3.1% |
| Other Punctuation | 1193753 | 1.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 13022254 | |
| t | 10171267 | |
| o | 9815413 | |
| n | 8477997 | |
| i | 7080956 | 7.8% |
| a | 6377179 | 7.0% |
| d | 4473449 | 4.9% |
| r | 4296068 | 4.7% |
| p | 3864689 | 4.3% |
| h | 3796931 | 4.2% |
| Other values (15) | 19317942 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1163026 | |
| D | 1157925 | |
| T | 1157893 | |
| Y | 10234 | 0.3% |
| S | 5101 | 0.1% |
| R | 5101 | 0.1% |
| N | 5101 | 0.1% |
| C | 5101 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1173228 | |
| ' | 20525 | 1.7% |
Space Separator
| Value | Count | Frequency (%) |
| 16016367 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 94203627 | |
| Common | 17210120 | 15.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 13022254 | |
| t | 10171267 | |
| o | 9815413 | |
| n | 8477997 | 9.0% |
| i | 7080956 | 7.5% |
| a | 6377179 | 6.8% |
| d | 4473449 | 4.7% |
| r | 4296068 | 4.6% |
| p | 3864689 | 4.1% |
| h | 3796931 | 4.0% |
| Other values (23) | 22827424 |
Common
| Value | Count | Frequency (%) |
| 16016367 | ||
| . | 1173228 | 6.8% |
| ' | 20525 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 111413747 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 16016367 | ||
| e | 13022254 | |
| t | 10171267 | 9.1% |
| o | 9815413 | 8.8% |
| n | 8477997 | 7.6% |
| i | 7080956 | 6.4% |
| a | 6377179 | 5.7% |
| d | 4473449 | 4.0% |
| r | 4296068 | 3.9% |
| p | 3864689 | 3.5% |
| Other values (26) | 27818108 |
| Distinct | 1139291 |
|---|---|
| Distinct (%) | 98.0% |
| Missing | 143 |
| Missing (%) | < 0.1% |
| Memory size | 8.9 MiB |
| Minimum | 2021-01-01 00:47:12 |
|---|---|
| Maximum | 2023-12-04 02:20:49 |
community_board
Text
| Distinct | 77 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 21 |
| Mean length | 10.242158 |
| Min length | 8 |
Characters and Unicode
| Total characters | 11914344 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 11 BROOKLYN |
|---|---|
| 2nd row | 05 QUEENS |
| 3rd row | 05 QUEENS |
| 4th row | 05 QUEENS |
| 5th row | 09 BRONX |
| Value | Count | Frequency (%) |
| brooklyn | 420506 | |
| queens | 350901 | |
| bronx | 194686 | 8.3% |
| manhattan | 163830 | 6.9% |
| 05 | 124005 | 5.3% |
| 01 | 101883 | 4.3% |
| 02 | 101616 | 4.3% |
| 12 | 96374 | 4.1% |
| 07 | 83325 | 3.5% |
| 10 | 81969 | 3.5% |
| Other values (28) | 639560 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1358003 | 11.4% |
| 1195390 | 10.0% | |
| O | 1035698 | 8.7% |
| 0 | 841607 | 7.1% |
| E | 733927 | 6.2% |
| B | 615192 | 5.2% |
| R | 615192 | 5.2% |
| 1 | 576718 | 4.8% |
| A | 555740 | 4.7% |
| L | 452631 | 3.8% |
| Other values (27) | 3934246 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 8312671 | |
| Decimal Number | 2308113 | 19.4% |
| Space Separator | 1195390 | 10.0% |
| Lowercase Letter | 98170 | 0.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1358003 | |
| O | 1035698 | |
| E | 733927 | |
| B | 615192 | 7.4% |
| R | 615192 | 7.4% |
| A | 555740 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.1% |
| K | 420506 | 5.1% |
| S | 415151 | 5.0% |
| Other values (8) | 1690125 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 841607 | |
| 1 | 576718 | |
| 2 | 198443 | 8.6% |
| 5 | 147952 | 6.4% |
| 3 | 106300 | 4.6% |
| 8 | 103209 | 4.5% |
| 4 | 99558 | 4.3% |
| 7 | 97250 | 4.2% |
| 9 | 74221 | 3.2% |
| 6 | 62855 | 2.7% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 19634 | |
| i | 19634 | |
| n | 9817 | |
| s | 9817 | |
| p | 9817 | |
| c | 9817 | |
| f | 9817 | |
| d | 9817 |
Space Separator
| Value | Count | Frequency (%) |
| 1195390 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8410841 | |
| Common | 3503503 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1358003 | |
| O | 1035698 | |
| E | 733927 | |
| B | 615192 | 7.3% |
| R | 615192 | 7.3% |
| A | 555740 | 6.6% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.0% |
| K | 420506 | 5.0% |
| S | 415151 | 4.9% |
| Other values (16) | 1788295 |
Common
| Value | Count | Frequency (%) |
| 1195390 | ||
| 0 | 841607 | |
| 1 | 576718 | |
| 2 | 198443 | 5.7% |
| 5 | 147952 | 4.2% |
| 3 | 106300 | 3.0% |
| 8 | 103209 | 2.9% |
| 4 | 99558 | 2.8% |
| 7 | 97250 | 2.8% |
| 9 | 74221 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11914344 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1358003 | 11.4% |
| 1195390 | 10.0% | |
| O | 1035698 | 8.7% |
| 0 | 841607 | 7.1% |
| E | 733927 | 6.2% |
| B | 615192 | 5.2% |
| R | 615192 | 5.2% |
| 1 | 576718 | 4.8% |
| A | 555740 | 4.7% |
| L | 452631 | 3.8% |
| Other values (27) | 3934246 |
bbl
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 189357 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 141586 |
| Missing (%) | 12.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9321783 × 109 |
| Minimum | 0 |
|---|---|
| Maximum | 5.2700005 × 109 |
| Zeros | 106 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.0103 × 109 |
| Q1 | 2.03886 × 109 |
| median | 3.04232 × 109 |
| Q3 | 4.0163551 × 109 |
| 95-th percentile | 4.1210801 × 109 |
| Maximum | 5.2700005 × 109 |
| Range | 5.2700005 × 109 |
| Interquartile range (IQR) | 1.9774951 × 109 |
Descriptive statistics
| Standard deviation | 1.0777252 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.36755104 |
| Kurtosis | -0.72782756 |
| Mean | 2.9321783 × 109 |
| Median Absolute Deviation (MAD) | 9.8743998 × 108 |
| Skewness | -0.38444472 |
| Sum | 2.995745 × 1015 |
| Variance | 1.1614915 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3003370027 | 4261 | 0.4% |
| 4068290001 | 3058 | 0.3% |
| 3001340006 | 2087 | 0.2% |
| 2038860002 | 2064 | 0.2% |
| 2038740063 | 2059 | 0.2% |
| 3020410001 | 1972 | 0.2% |
| 3044520423 | 1900 | 0.2% |
| 2024580026 | 1569 | 0.1% |
| 1021610001 | 1523 | 0.1% |
| 2032500046 | 1506 | 0.1% |
| Other values (189347) | 999680 | |
| (Missing) | 141586 | 12.2% |
| Value | Count | Frequency (%) |
| 0 | 106 | |
| 1000010201 | 1 | < 0.1% |
| 1000020001 | 2 | < 0.1% |
| 1000020002 | 40 | < 0.1% |
| 1000020023 | 4 | < 0.1% |
| 1000030001 | 2 | < 0.1% |
| 1000030010 | 8 | < 0.1% |
| 1000047501 | 16 | < 0.1% |
| 1000050010 | 1 | < 0.1% |
| 1000057501 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 5270000501 | 2 | |
| 5240009997 | 2 | |
| 5200459999 | 1 | |
| 5200169999 | 1 | |
| 5200039999 | 1 | |
| 5080500089 | 1 | |
| 5080500078 | 1 | |
| 5080500053 | 1 | |
| 5080500025 | 2 | |
| 5080500007 | 2 |
borough
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| BROOKLYN | |
|---|---|
| QUEENS | |
| BRONX | |
| MANHATTAN | |
| STATEN ISLAND | 32125 |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.177221 |
| Min length | 5 |
Characters and Unicode
| Total characters | 8349010 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | QUEENS |
| 3rd row | QUEENS |
| 4th row | QUEENS |
| 5th row | BRONX |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 420506 | |
| QUEENS | 350901 | |
| BRONX | 194525 | |
| MANHATTAN | 163991 | 14.1% |
| STATEN ISLAND | 32125 | 2.8% |
| Unspecified | 1217 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 420506 | |
| queens | 350901 | |
| bronx | 194525 | |
| manhattan | 163991 | 13.7% |
| staten | 32125 | 2.7% |
| island | 32125 | 2.7% |
| unspecified | 1217 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.0% |
| K | 420506 | 5.0% |
| S | 415151 | 5.0% |
| Other values (17) | 1726303 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 8304715 | |
| Space Separator | 32125 | 0.4% |
| Lowercase Letter | 12170 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.5% |
| Y | 420506 | 5.1% |
| K | 420506 | 5.1% |
| S | 415151 | 5.0% |
| Other values (8) | 1682008 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2434 | |
| i | 2434 | |
| n | 1217 | |
| s | 1217 | |
| p | 1217 | |
| c | 1217 | |
| f | 1217 | |
| d | 1217 |
Space Separator
| Value | Count | Frequency (%) |
| 32125 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8316885 | |
| Common | 32125 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.1% |
| K | 420506 | 5.1% |
| S | 415151 | 5.0% |
| Other values (16) | 1694178 |
Common
| Value | Count | Frequency (%) |
| 32125 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8349010 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.0% |
| K | 420506 | 5.0% |
| S | 415151 | 5.0% |
| Other values (17) | 1726303 |
x_coordinate_state_plane
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 86282 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 8818 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1005924.5 |
| Minimum | 913444 |
|---|---|
| Maximum | 1067281 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 913444 |
|---|---|
| 5-th percentile | 980246 |
| Q1 | 991567 |
| median | 1005207 |
| Q3 | 1019202 |
| 95-th percentile | 1041052 |
| Maximum | 1067281 |
| Range | 153837 |
| Interquartile range (IQR) | 27635 |
Descriptive statistics
| Standard deviation | 20689.199 |
|---|---|
| Coefficient of variation (CV) | 0.020567347 |
| Kurtosis | 1.3975799 |
| Mean | 1005924.5 |
| Median Absolute Deviation (MAD) | 13819 |
| Skewness | -0.21523733 |
| Sum | 1.1612865 × 1012 |
| Variance | 4.2804294 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 984166 | 4273 | 0.4% |
| 1037000 | 3066 | 0.3% |
| 1045818 | 2342 | 0.2% |
| 987324 | 2253 | 0.2% |
| 1020596 | 2068 | 0.2% |
| 988901 | 2056 | 0.2% |
| 987322 | 2032 | 0.2% |
| 1019422 | 1739 | 0.1% |
| 1011682 | 1655 | 0.1% |
| 1003772 | 1548 | 0.1% |
| Other values (86272) | 1131415 | |
| (Missing) | 8818 | 0.8% |
| Value | Count | Frequency (%) |
| 913444 | 1 | < 0.1% |
| 913469 | 1 | < 0.1% |
| 913503 | 1 | < 0.1% |
| 913526 | 1 | < 0.1% |
| 913533 | 3 | |
| 913586 | 2 | |
| 913596 | 1 | < 0.1% |
| 913613 | 1 | < 0.1% |
| 913712 | 2 | |
| 913754 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1067281 | 1 | < 0.1% |
| 1067180 | 1 | < 0.1% |
| 1067173 | 1 | < 0.1% |
| 1067166 | 1 | < 0.1% |
| 1067131 | 2 | < 0.1% |
| 1067126 | 1 | < 0.1% |
| 1067125 | 4 | |
| 1067124 | 1 | < 0.1% |
| 1067123 | 5 | |
| 1067120 | 2 | < 0.1% |
y_coordinate_state_plane
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 105519 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 8623 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203243.9 |
| Minimum | 121316 |
|---|---|
| Maximum | 271876 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 121316 |
|---|---|
| 5-th percentile | 156819 |
| Q1 | 183156 |
| median | 199404 |
| Q3 | 222639 |
| 95-th percentile | 256961 |
| Maximum | 271876 |
| Range | 150560 |
| Interquartile range (IQR) | 39483 |
Descriptive statistics
| Standard deviation | 30517.865 |
|---|---|
| Coefficient of variation (CV) | 0.1501539 |
| Kurtosis | -0.70698976 |
| Mean | 203243.9 |
| Median Absolute Deviation (MAD) | 19731 |
| Skewness | 0.23256208 |
| Sum | 2.3467394 × 1011 |
| Variance | 9.3134007 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 188346 | 4268 | 0.4% |
| 202363 | 3077 | 0.3% |
| 210166 | 2339 | 0.2% |
| 192647 | 2073 | 0.2% |
| 242945 | 2064 | 0.2% |
| 177846 | 1717 | 0.1% |
| 250722 | 1529 | 0.1% |
| 191913 | 1419 | 0.1% |
| 264242 | 1396 | 0.1% |
| 243713 | 1368 | 0.1% |
| Other values (105509) | 1133392 | |
| (Missing) | 8623 | 0.7% |
| Value | Count | Frequency (%) |
| 121316 | 1 | < 0.1% |
| 121374 | 1 | < 0.1% |
| 121519 | 1 | < 0.1% |
| 121544 | 1 | < 0.1% |
| 121586 | 3 | |
| 121677 | 1 | < 0.1% |
| 121702 | 1 | < 0.1% |
| 121730 | 1 | < 0.1% |
| 121750 | 1 | < 0.1% |
| 121755 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 271876 | 40 | |
| 271730 | 10 | < 0.1% |
| 271676 | 50 | |
| 271667 | 1 | < 0.1% |
| 271664 | 1 | < 0.1% |
| 271641 | 2 | < 0.1% |
| 271628 | 1 | < 0.1% |
| 271622 | 1 | < 0.1% |
| 271621 | 2 | < 0.1% |
| 271598 | 1 | < 0.1% |
open_data_channel_type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| MOBILE | |
|---|---|
| ONLINE | |
| PHONE | |
| UNKNOWN | 124 |
| OTHER | 40 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.8236507 |
| Min length | 5 |
Characters and Unicode
| Total characters | 6774449 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ONLINE |
|---|---|
| 2nd row | ONLINE |
| 3rd row | ONLINE |
| 4th row | ONLINE |
| 5th row | MOBILE |
Common Values
| Value | Count | Frequency (%) |
| MOBILE | 527056 | |
| ONLINE | 430820 | |
| PHONE | 205225 | 17.6% |
| UNKNOWN | 124 | < 0.1% |
| OTHER | 40 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mobile | 527056 | |
| online | 430820 | |
| phone | 205225 | 17.6% |
| unknown | 124 | < 0.1% |
| other | 40 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 1163265 | |
| E | 1163141 | |
| N | 1067237 | |
| I | 957876 | |
| L | 957876 | |
| M | 527056 | |
| B | 527056 | |
| H | 205265 | 3.0% |
| P | 205225 | 3.0% |
| U | 124 | < 0.1% |
| Other values (4) | 328 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6774449 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1163265 | |
| E | 1163141 | |
| N | 1067237 | |
| I | 957876 | |
| L | 957876 | |
| M | 527056 | |
| B | 527056 | |
| H | 205265 | 3.0% |
| P | 205225 | 3.0% |
| U | 124 | < 0.1% |
| Other values (4) | 328 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6774449 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 1163265 | |
| E | 1163141 | |
| N | 1067237 | |
| I | 957876 | |
| L | 957876 | |
| M | 527056 | |
| B | 527056 | |
| H | 205265 | 3.0% |
| P | 205225 | 3.0% |
| U | 124 | < 0.1% |
| Other values (4) | 328 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6774449 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 1163265 | |
| E | 1163141 | |
| N | 1067237 | |
| I | 957876 | |
| L | 957876 | |
| M | 527056 | |
| B | 527056 | |
| H | 205265 | 3.0% |
| P | 205225 | 3.0% |
| U | 124 | < 0.1% |
| Other values (4) | 328 | < 0.1% |
park_facility_name
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| Unspecified | |
|---|---|
| Police Museum | 1 |
| 121 PRECINCT | 1 |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.000003 |
| Min length | 11 |
Characters and Unicode
| Total characters | 12795918 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Unspecified |
|---|---|
| 2nd row | Unspecified |
| 3rd row | Unspecified |
| 4th row | Unspecified |
| 5th row | Unspecified |
Common Values
| Value | Count | Frequency (%) |
| Unspecified | 1163263 | |
| Police Museum | 1 | < 0.1% |
| 121 PRECINCT | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| unspecified | 1163263 | |
| police | 1 | < 0.1% |
| museum | 1 | < 0.1% |
| 121 | 1 | < 0.1% |
| precinct | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2326528 | |
| i | 2326527 | |
| s | 1163264 | |
| c | 1163264 | |
| U | 1163263 | |
| n | 1163263 | |
| p | 1163263 | |
| f | 1163263 | |
| d | 1163263 | |
| C | 2 | < 0.1% |
| Other values (14) | 18 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 11632640 | |
| Uppercase Letter | 1163273 | 9.1% |
| Decimal Number | 3 | < 0.1% |
| Space Separator | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2326528 | |
| i | 2326527 | |
| s | 1163264 | |
| c | 1163264 | |
| n | 1163263 | |
| p | 1163263 | |
| f | 1163263 | |
| d | 1163263 | |
| u | 2 | < 0.1% |
| l | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 1163263 | |
| C | 2 | < 0.1% |
| P | 2 | < 0.1% |
| M | 1 | < 0.1% |
| R | 1 | < 0.1% |
| E | 1 | < 0.1% |
| I | 1 | < 0.1% |
| N | 1 | < 0.1% |
| T | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 2 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12795913 | |
| Common | 5 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2326528 | |
| i | 2326527 | |
| s | 1163264 | |
| c | 1163264 | |
| U | 1163263 | |
| n | 1163263 | |
| p | 1163263 | |
| f | 1163263 | |
| d | 1163263 | |
| C | 2 | < 0.1% |
| Other values (11) | 13 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 2 | ||
| 2 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12795918 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 2326528 | |
| i | 2326527 | |
| s | 1163264 | |
| c | 1163264 | |
| U | 1163263 | |
| n | 1163263 | |
| p | 1163263 | |
| f | 1163263 | |
| d | 1163263 | |
| C | 2 | < 0.1% |
| Other values (14) | 18 | < 0.1% |
park_borough
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
| BROOKLYN | |
|---|---|
| QUEENS | |
| BRONX | |
| MANHATTAN | |
| STATEN ISLAND | 32125 |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.177221 |
| Min length | 5 |
Characters and Unicode
| Total characters | 8349010 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | QUEENS |
| 3rd row | QUEENS |
| 4th row | QUEENS |
| 5th row | BRONX |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 420506 | |
| QUEENS | 350901 | |
| BRONX | 194525 | |
| MANHATTAN | 163991 | 14.1% |
| STATEN ISLAND | 32125 | 2.8% |
| Unspecified | 1217 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 420506 | |
| queens | 350901 | |
| bronx | 194525 | |
| manhattan | 163991 | 13.7% |
| staten | 32125 | 2.7% |
| island | 32125 | 2.7% |
| unspecified | 1217 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.0% |
| K | 420506 | 5.0% |
| S | 415151 | 5.0% |
| Other values (17) | 1726303 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 8304715 | |
| Space Separator | 32125 | 0.4% |
| Lowercase Letter | 12170 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.5% |
| Y | 420506 | 5.1% |
| K | 420506 | 5.1% |
| S | 415151 | 5.0% |
| Other values (8) | 1682008 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2434 | |
| i | 2434 | |
| n | 1217 | |
| s | 1217 | |
| p | 1217 | |
| c | 1217 | |
| f | 1217 | |
| d | 1217 |
Space Separator
| Value | Count | Frequency (%) |
| 32125 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8316885 | |
| Common | 32125 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.1% |
| K | 420506 | 5.1% |
| S | 415151 | 5.0% |
| Other values (16) | 1694178 |
Common
| Value | Count | Frequency (%) |
| 32125 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8349010 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1358164 | |
| O | 1035537 | |
| E | 733927 | |
| B | 615031 | 7.4% |
| R | 615031 | 7.4% |
| A | 556223 | 6.7% |
| L | 452631 | 5.4% |
| Y | 420506 | 5.0% |
| K | 420506 | 5.0% |
| S | 415151 | 5.0% |
| Other values (17) | 1726303 |
latitude
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 284474 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 8838 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.724477 |
| Minimum | 40.499409 |
|---|---|
| Maximum | 40.912869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | 40.499409 |
|---|---|
| 5-th percentile | 40.597021 |
| Q1 | 40.669323 |
| median | 40.71392 |
| Q3 | 40.77768 |
| 95-th percentile | 40.871925 |
| Maximum | 40.912869 |
| Range | 0.41346008 |
| Interquartile range (IQR) | 0.10835694 |
Descriptive statistics
| Standard deviation | 0.083757439 |
|---|---|
| Coefficient of variation (CV) | 0.0020566854 |
| Kurtosis | -0.70651246 |
| Mean | 40.724477 |
| Median Absolute Deviation (MAD) | 0.054189086 |
| Skewness | 0.23263872 |
| Sum | 47013436 |
| Variance | 0.0070153086 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.68364303 | 4261 | 0.4% |
| 40.72195913 | 3059 | 0.3% |
| 40.74331941 | 2337 | 0.2% |
| 40.83342849 | 2061 | 0.2% |
| 40.69544706 | 2051 | 0.2% |
| 40.65475302 | 1717 | 0.1% |
| 40.85482728 | 1520 | 0.1% |
| 40.69343309 | 1403 | 0.1% |
| 40.89187242 | 1396 | 0.1% |
| 40.83554666 | 1361 | 0.1% |
| Other values (284464) | 1133261 | |
| (Missing) | 8838 | 0.8% |
| Value | Count | Frequency (%) |
| 40.49940871 | 1 | < 0.1% |
| 40.49956978 | 1 | < 0.1% |
| 40.49996957 | 1 | < 0.1% |
| 40.50002606 | 1 | < 0.1% |
| 40.50014121 | 3 | |
| 40.50039682 | 1 | < 0.1% |
| 40.50046544 | 1 | < 0.1% |
| 40.50054219 | 1 | < 0.1% |
| 40.50057897 | 1 | < 0.1% |
| 40.50062032 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.9128688 | 40 | |
| 40.91246817 | 10 | < 0.1% |
| 40.91231946 | 50 | |
| 40.91229474 | 1 | < 0.1% |
| 40.91228642 | 1 | < 0.1% |
| 40.91222312 | 2 | < 0.1% |
| 40.91218664 | 1 | < 0.1% |
| 40.91217017 | 1 | < 0.1% |
| 40.91216807 | 2 | < 0.1% |
| 40.91210338 | 1 | < 0.1% |
longitude
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 284471 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 8838 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.921767 |
| Minimum | -74.254624 |
|---|---|
| Maximum | -73.700376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1154427 |
| Negative (%) | 99.2% |
| Memory size | 8.9 MiB |
Quantile statistics
| Minimum | -74.254624 |
|---|---|
| 5-th percentile | -74.014426 |
| Q1 | -73.973613 |
| median | -73.924364 |
| Q3 | -73.873805 |
| 95-th percentile | -73.795137 |
| Maximum | -73.700376 |
| Range | 0.55424813 |
| Interquartile range (IQR) | 0.099808523 |
Descriptive statistics
| Standard deviation | 0.074627547 |
|---|---|
| Coefficient of variation (CV) | -0.0010095477 |
| Kurtosis | 1.3832865 |
| Mean | -73.921767 |
| Median Absolute Deviation (MAD) | 0.04990471 |
| Skewness | -0.21307527 |
| Sum | -85337283 |
| Variance | 0.0055692708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -74.00030287 | 4261 | 0.4% |
| -73.80969682 | 3059 | 0.3% |
| -73.77781335 | 2337 | 0.2% |
| -73.86865697 | 2061 | 0.2% |
| -73.98322754 | 2051 | 0.2% |
| -73.87323986 | 1717 | 0.1% |
| -73.92943095 | 1520 | 0.1% |
| -73.98891486 | 1403 | 0.1% |
| -73.86016845 | 1396 | 0.1% |
| -73.87797279 | 1361 | 0.1% |
| Other values (284461) | 1133261 | |
| (Missing) | 8838 | 0.8% |
| Value | Count | Frequency (%) |
| -74.25462445 | 1 | < 0.1% |
| -74.25453162 | 1 | < 0.1% |
| -74.25440803 | 1 | < 0.1% |
| -74.25433153 | 1 | < 0.1% |
| -74.2543014 | 3 | |
| -74.25411077 | 2 | |
| -74.25407768 | 1 | < 0.1% |
| -74.25401918 | 1 | < 0.1% |
| -74.25365765 | 2 | |
| -74.2535115 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.70037632 | 1 | < 0.1% |
| -73.70073668 | 1 | < 0.1% |
| -73.7007611 | 1 | < 0.1% |
| -73.70078552 | 1 | < 0.1% |
| -73.70090631 | 2 | |
| -73.70092367 | 1 | < 0.1% |
| -73.70092713 | 3 | |
| -73.70092798 | 1 | < 0.1% |
| -73.70093144 | 1 | < 0.1% |
| -73.70093408 | 4 |
location
Text
| Distinct | 284474 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 8838 |
| Missing (%) | 0.8% |
| Memory size | 8.9 MiB |
Length
| Max length | 141 |
|---|---|
| Median length | 140 |
| Mean length | 140.05185 |
| Min length | 127 |
Characters and Unicode
| Total characters | 161679641 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 156427 ? |
|---|---|
| Unique (%) | 13.6% |
Sample
| 1st row | {'latitude': '40.59842551366083', 'longitude': '-73.99386035358324', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
|---|---|
| 2nd row | {'latitude': '40.703605926745354', 'longitude': '-73.89356421159655', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 3rd row | {'latitude': '40.7038420696995', 'longitude': '-73.89366482112014', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 4th row | {'latitude': '40.702568005237964', 'longitude': '-73.89313307748259', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 5th row | {'latitude': '40.840250548425054', 'longitude': '-73.86515232413545', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| Value | Count | Frequency (%) |
| 4617708 | ||
| latitude | 1154427 | 7.7% |
| state | 1154427 | 7.7% |
| longitude | 1154427 | 7.7% |
| zip | 1154427 | 7.7% |
| human_address | 1154427 | 7.7% |
| address | 1154427 | 7.7% |
| city | 1154427 | 7.7% |
| 40.68364302931577 | 4261 | < 0.1% |
| 74.00030286766025 | 4261 | < 0.1% |
| Other values (568943) | 2300332 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 18470832 | 11.4% |
| 13853124 | 8.6% | |
| ' | 13853124 | 8.6% |
| : | 8080989 | 5.0% |
| t | 6926562 | 4.3% |
| d | 6926562 | 4.3% |
| a | 5772135 | 3.6% |
| e | 5772135 | 3.6% |
| , | 5772135 | 3.6% |
| s | 5772135 | 3.6% |
| Other values (28) | 70479908 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 55412496 | |
| Other Punctuation | 48485934 | |
| Decimal Number | 37001525 | |
| Space Separator | 13853124 | 8.6% |
| Open Punctuation | 2308854 | 1.4% |
| Close Punctuation | 2308854 | 1.4% |
| Dash Punctuation | 1154427 | 0.7% |
| Connector Punctuation | 1154427 | 0.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 6926562 | |
| d | 6926562 | |
| a | 5772135 | |
| e | 5772135 | |
| s | 5772135 | |
| i | 4617708 | |
| u | 3463281 | 6.2% |
| n | 2308854 | 4.2% |
| r | 2308854 | 4.2% |
| l | 2308854 | 4.2% |
| Other values (8) | 9235416 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 4632740 | |
| 4 | 4358671 | |
| 3 | 4047455 | |
| 0 | 4034998 | |
| 8 | 3640261 | |
| 9 | 3632288 | |
| 6 | 3545179 | |
| 5 | 3158313 | |
| 2 | 2991985 | |
| 1 | 2959635 |
Other Punctuation
| Value | Count | Frequency (%) |
| " | 18470832 | |
| ' | 13853124 | |
| : | 8080989 | |
| , | 5772135 | 11.9% |
| . | 2308854 | 4.8% |
Space Separator
| Value | Count | Frequency (%) |
| 13853124 |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 2308854 |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 2308854 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1154427 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1154427 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 106267145 | |
| Latin | 55412496 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| " | 18470832 | |
| 13853124 | ||
| ' | 13853124 | |
| : | 8080989 | 7.6% |
| , | 5772135 | 5.4% |
| 7 | 4632740 | 4.4% |
| 4 | 4358671 | 4.1% |
| 3 | 4047455 | 3.8% |
| 0 | 4034998 | 3.8% |
| 8 | 3640261 | 3.4% |
| Other values (10) | 25522816 |
Latin
| Value | Count | Frequency (%) |
| t | 6926562 | |
| d | 6926562 | |
| a | 5772135 | |
| e | 5772135 | |
| s | 5772135 | |
| i | 4617708 | |
| u | 3463281 | 6.2% |
| n | 2308854 | 4.2% |
| r | 2308854 | 4.2% |
| l | 2308854 | 4.2% |
| Other values (8) | 9235416 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 161679641 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| " | 18470832 | 11.4% |
| 13853124 | 8.6% | |
| ' | 13853124 | 8.6% |
| : | 8080989 | 5.0% |
| t | 6926562 | 4.3% |
| d | 6926562 | 4.3% |
| a | 5772135 | 3.6% |
| e | 5772135 | 3.6% |
| , | 5772135 | 3.6% |
| s | 5772135 | 3.6% |
| Other values (28) | 70479908 |
| address_type | bbl | borough | city | descriptor | incident_zip | latitude | longitude | open_data_channel_type | park_borough | park_facility_name | resolution_description | status | unique_key | x_coordinate_state_plane | y_coordinate_state_plane | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| address_type | 1.000 | -0.002 | 0.035 | 0.613 | 0.105 | 0.025 | 0.011 | 0.061 | 0.143 | 0.035 | 1.000 | 0.022 | 0.001 | -0.004 | 0.061 | 0.012 |
| bbl | -0.002 | 1.000 | 0.892 | 0.665 | 0.112 | 0.795 | -0.487 | 0.363 | 0.047 | 0.892 | 0.005 | 0.065 | 0.006 | -0.004 | 0.363 | -0.486 |
| borough | 0.035 | 0.892 | 1.000 | 0.894 | 0.149 | 0.392 | -0.175 | 0.164 | 0.044 | 1.000 | 0.003 | 0.085 | 0.007 | -0.005 | 0.165 | -0.175 |
| city | 0.613 | 0.665 | 0.894 | 1.000 | 0.121 | 0.193 | -0.189 | -0.036 | 0.085 | 0.894 | 0.000 | 0.087 | 0.011 | -0.017 | -0.036 | -0.188 |
| descriptor | 0.105 | 0.112 | 0.149 | 0.121 | 1.000 | -0.027 | -0.010 | -0.010 | 0.147 | 0.149 | 0.000 | 0.097 | 0.006 | -0.018 | -0.010 | -0.010 |
| incident_zip | 0.025 | 0.795 | 0.392 | 0.193 | -0.027 | 1.000 | -0.444 | 0.452 | 0.057 | 0.683 | 0.000 | 0.062 | 0.004 | -0.002 | 0.453 | -0.444 |
| latitude | 0.011 | -0.487 | -0.175 | -0.189 | -0.010 | -0.444 | 1.000 | 0.407 | 0.052 | 0.570 | 0.001 | 0.065 | 0.004 | -0.017 | 0.406 | 1.000 |
| longitude | 0.061 | 0.363 | 0.164 | -0.036 | -0.010 | 0.452 | 0.407 | 1.000 | 0.058 | 0.581 | 0.007 | 0.059 | 0.007 | -0.050 | 1.000 | 0.407 |
| open_data_channel_type | 0.143 | 0.047 | 0.044 | 0.085 | 0.147 | 0.057 | 0.052 | 0.058 | 1.000 | 0.044 | 0.000 | 0.032 | 0.000 | -0.005 | 0.046 | -0.024 |
| park_borough | 0.035 | 0.892 | 1.000 | 0.894 | 0.149 | 0.683 | 0.570 | 0.581 | 0.044 | 1.000 | 0.003 | 0.085 | 0.007 | -0.005 | 0.165 | -0.175 |
| park_facility_name | 1.000 | 0.005 | 0.003 | 0.000 | 0.000 | 0.000 | 0.001 | 0.007 | 0.000 | 0.003 | 1.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 |
| resolution_description | 0.022 | 0.065 | 0.085 | 0.087 | 0.097 | 0.062 | 0.065 | 0.059 | 0.032 | 0.085 | 0.000 | 1.000 | 0.125 | -0.034 | -0.046 | 0.050 |
| status | 0.001 | 0.006 | 0.007 | 0.011 | 0.006 | 0.004 | 0.004 | 0.007 | 0.000 | 0.007 | 0.000 | 0.125 | 1.000 | 0.019 | 0.008 | 0.003 |
| unique_key | -0.004 | -0.004 | -0.005 | -0.017 | -0.018 | -0.002 | -0.017 | -0.050 | -0.005 | -0.005 | 0.002 | -0.034 | 0.019 | 1.000 | -0.050 | -0.017 |
| x_coordinate_state_plane | 0.061 | 0.363 | 0.165 | -0.036 | -0.010 | 0.453 | 0.406 | 1.000 | 0.046 | 0.165 | 0.000 | -0.046 | 0.008 | -0.050 | 1.000 | 0.406 |
| y_coordinate_state_plane | 0.012 | -0.486 | -0.175 | -0.188 | -0.010 | -0.444 | 1.000 | 0.407 | -0.024 | -0.175 | 0.000 | 0.050 | 0.003 | -0.017 | 0.406 | 1.000 |
| unique_key | created_date | closed_date | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | street_name | cross_street_1 | cross_street_2 | intersection_street_1 | intersection_street_2 | address_type | city | landmark | status | resolution_description | resolution_action_updated_date | community_board | bbl | borough | x_coordinate_state_plane | y_coordinate_state_plane | open_data_channel_type | park_facility_name | park_borough | latitude | longitude | location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 52934348 | 2021-12-31T23:58:51.000 | 2022-01-01T01:00:41.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11214.0 | 8700 23 AVENUE | 23 AVENUE | BENSON AVENUE | BATH AVENUE | BENSON AVENUE | BATH AVENUE | ADDRESS | BROOKLYN | 23 AVENUE | Closed | The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. | 2022-01-01T01:00:44.000 | 11 BROOKLYN | 3.064170e+09 | BROOKLYN | 985955.0 | 157299.0 | ONLINE | Unspecified | BROOKLYN | 40.598426 | -73.993860 | {'latitude': '40.59842551366083', 'longitude': '-73.99386035358324', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1 | 52938513 | 2021-12-31T23:58:36.000 | 2022-01-01T02:36:38.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11385.0 | 69-41 64 STREET | 64 STREET | CATALPA AVENUE | SHALER AVENUE | CATALPA AVENUE | SHALER AVENUE | ADDRESS | RIDGEWOOD | 64 STREET | Closed | The Police Department issued a summons in response to the complaint. | 2022-01-01T02:36:42.000 | 05 QUEENS | 4.036320e+09 | QUEENS | 1013761.0 | 195637.0 | ONLINE | Unspecified | QUEENS | 40.703606 | -73.893564 | {'latitude': '40.703605926745354', 'longitude': '-73.89356421159655', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 2 | 52937700 | 2021-12-31T23:56:20.000 | 2022-01-01T02:36:19.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11385.0 | 69-23 64 STREET | 64 STREET | CATALPA AVENUE | SHALER AVENUE | CATALPA AVENUE | SHALER AVENUE | ADDRESS | RIDGEWOOD | 64 STREET | Closed | The Police Department issued a summons in response to the complaint. | 2022-01-01T02:36:24.000 | 05 QUEENS | 4.036320e+09 | QUEENS | 1013733.0 | 195723.0 | ONLINE | Unspecified | QUEENS | 40.703842 | -73.893665 | {'latitude': '40.7038420696995', 'longitude': '-73.89366482112014', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 3 | 52931661 | 2021-12-31T23:54:13.000 | 2022-01-01T02:35:59.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11385.0 | 64 STREET | 64 STREET | 64 STREET | SHALER AVENUE | 64 STREET | SHALER AVENUE | INTERSECTION | NaN | NaN | Closed | The Police Department issued a summons in response to the complaint. | 2022-01-01T02:36:04.000 | 05 QUEENS | NaN | QUEENS | 1013881.0 | 195259.0 | ONLINE | Unspecified | QUEENS | 40.702568 | -73.893133 | {'latitude': '40.702568005237964', 'longitude': '-73.89313307748259', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 4 | 52932718 | 2021-12-31T23:51:25.000 | 2022-01-01T01:30:40.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 10460.0 | 1577 LELAND AVENUE | LELAND AVENUE | GUERLAIN STREET | EAST TREMONT AVENUE | GUERLAIN STREET | EAST TREMONT AVENUE | ADDRESS | BRONX | LELAND AVENUE | Closed | The Police Department responded to the complaint and took action to fix the condition. | 2022-01-01T01:30:46.000 | 09 BRONX | 2.039260e+09 | BRONX | 1021562.0 | 245432.0 | MOBILE | Unspecified | BRONX | 40.840251 | -73.865152 | {'latitude': '40.840250548425054', 'longitude': '-73.86515232413545', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 5 | 52932000 | 2021-12-31T23:46:54.000 | 2022-01-01T01:17:46.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Crosswalk | Street/Sidewalk | 11207.0 | 77 VAN SICLEN AVENUE | VAN SICLEN AVENUE | ARLINGTON AVENUE | FULTON STREET | ARLINGTON AVENUE | FULTON STREET | ADDRESS | BROOKLYN | VAN SICLEN AVENUE | Closed | The Police Department responded to the complaint and took action to fix the condition. | 2022-01-01T01:17:55.000 | 05 BROOKLYN | 3.039330e+09 | BROOKLYN | 1014258.0 | 186533.0 | MOBILE | Unspecified | BROOKLYN | 40.678616 | -73.891812 | {'latitude': '40.67861589367691', 'longitude': '-73.8918122624042', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 6 | 52935750 | 2021-12-31T23:43:23.000 | 2022-01-01T02:11:03.000 | NYPD | New York City Police Department | Illegal Parking | Posted Parking Sign Violation | Street/Sidewalk | 11378.0 | 71-44 58 AVENUE | 58 AVENUE | 73 STREET | 73 PLACE | 73 STREET | 73 PLACE | ADDRESS | MASPETH | 58 AVENUE | Closed | The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. | 2022-01-01T02:11:08.000 | 05 QUEENS | 4.028190e+09 | QUEENS | 1015086.0 | 203863.0 | MOBILE | Unspecified | QUEENS | 40.726180 | -73.888748 | {'latitude': '40.72617979417831', 'longitude': '-73.88874772806905', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 7 | 52938071 | 2021-12-31T23:41:21.000 | 2022-01-01T01:10:36.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11226.0 | 25 PARADE PLACE | PARADE PLACE | WOODRUFF AVENUE | CROOKE AVENUE | WOODRUFF AVENUE | CROOKE AVENUE | ADDRESS | BROOKLYN | PARADE PLACE | Closed | The Police Department responded and upon arrival those responsible for the condition were gone. | 2022-01-01T01:10:40.000 | 14 BROOKLYN | 3.050580e+09 | BROOKLYN | 993777.0 | 176961.0 | MOBILE | Unspecified | BROOKLYN | 40.652389 | -73.965666 | {'latitude': '40.652388617370235', 'longitude': '-73.96566585079294', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 8 | 52932192 | 2021-12-31T23:41:12.000 | 2022-01-01T00:35:53.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11234.0 | 2068 EAST 61 STREET | EAST 61 STREET | AVENUE T | AVENUE U | AVENUE T | AVENUE U | ADDRESS | BROOKLYN | EAST 61 STREET | Closed | The Police Department responded to the complaint and took action to fix the condition. | 2022-01-01T00:35:55.000 | 18 BROOKLYN | 3.084030e+09 | BROOKLYN | 1007755.0 | 163534.0 | ONLINE | Unspecified | BROOKLYN | 40.615508 | -73.915338 | {'latitude': '40.615508300006354', 'longitude': '-73.91533762905237', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 9 | 52935371 | 2021-12-31T23:33:08.000 | 2022-01-01T01:14:18.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11435.0 | 139-11 87 DRIVE | 87 DRIVE | 139 STREET | 143 STREET | 139 STREET | 143 STREET | ADDRESS | JAMAICA | 87 DRIVE | Closed | The Police Department responded and upon arrival those responsible for the condition were gone. | 2022-01-01T01:14:21.000 | 08 QUEENS | 4.096990e+09 | QUEENS | 1035623.0 | 196313.0 | MOBILE | Unspecified | QUEENS | 40.705361 | -73.814711 | {'latitude': '40.70536146628257', 'longitude': '-73.81471070155054', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| unique_key | created_date | closed_date | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | street_name | cross_street_1 | cross_street_2 | intersection_street_1 | intersection_street_2 | address_type | city | landmark | status | resolution_description | resolution_action_updated_date | community_board | bbl | borough | x_coordinate_state_plane | y_coordinate_state_plane | open_data_channel_type | park_facility_name | park_borough | latitude | longitude | location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1163255 | 56414229 | 2023-01-01T00:19:59.000 | 2023-01-01T00:26:06.000 | NYPD | New York City Police Department | Illegal Parking | Double Parked Blocking Traffic | Street/Sidewalk | 10305.0 | 51 ANDREWS STREET | ANDREWS STREET | OLYMPIA BOULEVARD | QUINCY AVENUE | OLYMPIA BOULEVARD | QUINCY AVENUE | ADDRESS | STATEN ISLAND | ANDREWS STREET | Closed | The Police Department issued a summons in response to the complaint. | 2023-01-01T00:26:12.000 | 02 STATEN ISLAND | 5.034100e+09 | STATEN ISLAND | 964125.0 | 154621.0 | MOBILE | Unspecified | STATEN ISLAND | 40.591052 | -74.072461 | {'latitude': '40.59105225933984', 'longitude': '-74.07246143998023', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163256 | 56416365 | 2023-01-01T00:19:48.000 | 2023-01-01T05:51:47.000 | NYPD | New York City Police Department | Illegal Parking | Commercial Overnight Parking | Street/Sidewalk | 11366.0 | 196-69 73 AVENUE | 73 AVENUE | 196 PLACE | 197 STREET | 196 PLACE | 197 STREET | ADDRESS | FRESH MEADOWS | 73 AVENUE | Closed | The Police Department responded to the complaint and determined that police action was not necessary. | 2023-01-01T05:51:55.000 | 08 QUEENS | 4.071170e+09 | QUEENS | 1046424.0 | 207305.0 | ONLINE | Unspecified | QUEENS | 40.735462 | -73.775653 | {'latitude': '40.73546245678656', 'longitude': '-73.77565287060753', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163257 | 56414992 | 2023-01-01T00:16:28.000 | 2023-01-01T01:07:56.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 10462.0 | 1944 UNIONPORT ROAD | UNIONPORT ROAD | SAGAMORE STREET | BRONX PARK EAST | SAGAMORE STREET | BRONX PARK EAST | ADDRESS | BRONX | UNIONPORT ROAD | Closed | The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. | 2023-01-01T01:08:01.000 | 11 BRONX | 2.042560e+09 | BRONX | 1020522.0 | 248895.0 | PHONE | Unspecified | BRONX | 40.849760 | -73.868892 | {'latitude': '40.84975978935839', 'longitude': '-73.86889220514804', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163258 | 56416757 | 2023-01-01T00:16:18.000 | 2023-01-01T00:41:27.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11354.0 | 33-30 149 PLACE | 149 PLACE | 33 AVENUE | 34 AVENUE | 33 AVENUE | 34 AVENUE | ADDRESS | FLUSHING | 149 PLACE | Closed | The Police Department responded to the complaint and took action to fix the condition. | 2023-01-01T00:41:33.000 | 07 QUEENS | 4.049890e+09 | QUEENS | 1035097.0 | 219319.0 | ONLINE | Unspecified | QUEENS | 40.768510 | -73.816434 | {'latitude': '40.7685101446476', 'longitude': '-73.81643396042371', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163259 | 56418375 | 2023-01-01T00:14:05.000 | 2023-01-01T00:55:18.000 | NYPD | New York City Police Department | Illegal Parking | Commercial Overnight Parking | Street/Sidewalk | 11236.0 | 10516 AVENUE K | AVENUE K | EAST 105 STREET | EAST 108 STREET | EAST 105 STREET | EAST 108 STREET | ADDRESS | BROOKLYN | AVENUE K | Closed | The Police Department responded to the complaint and determined that police action was not necessary. | 2023-01-01T00:55:24.000 | 18 BROOKLYN | 3.082510e+09 | BROOKLYN | 1014650.0 | 174142.0 | MOBILE | Unspecified | BROOKLYN | 40.644604 | -73.890455 | {'latitude': '40.64460402376489', 'longitude': '-73.8904548539346', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163260 | 56415896 | 2023-01-01T00:11:43.000 | 2023-01-01T01:19:17.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11418.0 | 102-41 86 ROAD | 86 ROAD | 102 STREET | DEAD END | 102 STREET | DEAD END | ADDRESS | RICHMOND HILL | 86 ROAD | Closed | The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time. | 2023-01-01T01:19:24.000 | 09 QUEENS | 4.091860e+09 | QUEENS | 1027282.0 | 192796.0 | MOBILE | Unspecified | QUEENS | 40.695753 | -73.844817 | {'latitude': '40.69575263417357', 'longitude': '-73.84481696249556', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163261 | 56414264 | 2023-01-01T00:06:11.000 | 2023-01-01T03:30:43.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11378.0 | 60-24 56 ROAD | 56 ROAD | 60 STREET | 61 STREET | 60 STREET | 61 STREET | ADDRESS | MASPETH | 56 ROAD | Closed | The Police Department issued a summons in response to the complaint. | 2023-01-01T03:30:47.000 | 05 QUEENS | 4.027040e+09 | QUEENS | 1010402.0 | 203235.0 | MOBILE | Unspecified | QUEENS | 40.724471 | -73.905649 | {'latitude': '40.7244711757953', 'longitude': '-73.90564941620535', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163262 | 56416806 | 2023-01-01T00:03:42.000 | 2023-01-01T03:02:12.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | Street/Sidewalk | 11378.0 | 60-65 55 STREET | 55 STREET | NURGE AVENUE | ARNOLD AVENUE | NURGE AVENUE | ARNOLD AVENUE | ADDRESS | MASPETH | 55 STREET | Closed | The Police Department responded to the complaint and took action to fix the condition. | 2023-01-01T03:02:17.000 | 05 QUEENS | 4.026410e+09 | QUEENS | 1009096.0 | 199714.0 | MOBILE | Unspecified | QUEENS | 40.714811 | -73.910374 | {'latitude': '40.71481064814987', 'longitude': '-73.91037416673439', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163263 | 56418251 | 2023-01-01T00:01:50.000 | 2023-01-01T02:31:47.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Crosswalk | Street/Sidewalk | 11230.0 | BAY AVENUE | BAY AVENUE | BAY AVENUE | EAST 19 STREET | BAY AVENUE | EAST 19 STREET | INTERSECTION | NaN | NaN | Closed | The Police Department issued a summons in response to the complaint. | 2023-01-01T02:31:51.000 | 14 BROOKLYN | NaN | BROOKLYN | 996427.0 | 164395.0 | MOBILE | Unspecified | BROOKLYN | 40.617894 | -73.956138 | {'latitude': '40.61789437610167', 'longitude': '-73.95613825034788', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 1163264 | 56418795 | 2023-01-01T00:00:45.000 | 2023-01-01T01:24:10.000 | NYPD | New York City Police Department | Illegal Parking | Posted Parking Sign Violation | Street/Sidewalk | 10001.0 | 15 HUDSON BOULEVARD | HUDSON BOULEVARD | WEST 33 STREET | WEST 34 STREET | WEST 33 STREET | WEST 34 STREET | ADDRESS | NEW YORK | HUDSON BOULEVARD EAST | Closed | The Police Department responded to the complaint and determined that police action was not necessary. | 2023-01-01T01:24:16.000 | 04 MANHATTAN | 1.007050e+09 | MANHATTAN | 984043.0 | 214298.0 | MOBILE | Unspecified | MANHATTAN | 40.754875 | -74.000747 | {'latitude': '40.75487501846257', 'longitude': '-74.00074715055744', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |